Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » PostgreSQL function in query(Are they called?)
PostgreSQL function in query [message #1807591] Tue, 04 June 2019 09:59
Nicklas Karlsson is currently offline Nicklas KarlssonFriend
Messages: 34
Registered: July 2009
Member
What would be the correct way to pass parameters to a PostgreSQL function embedded in a query? If I have something like

select *
from foo
where is_access_ok(?)

or

select is_access_ok(?)

where is_access_ok is a function that takes a parameter and returns a boolean, I get an empty result (or a false in the second case) but the function is never called (it writes log information to a table)

Edit: upon logging in my exception branch, I noticed that the function is called but the parameters are passed in as plain question marks...

[Updated on: Tue, 04 June 2019 10:37]

Report message to a moderator

Previous Topic:BIRT shows only first chart in a report
Next Topic:Split Value into rows
Goto Forum:
  


Current Time: Sun Nov 17 04:51:51 GMT 2019

Powered by FUDForum. Page generated in 0.02248 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top