Eclipse Community Forums: BIRT » PostgreSQL function in query

Help

Home

Home » Eclipse Projects » BIRT » PostgreSQL function in query(Are they called?)

Show: Today's Messages :: Show Polls :: Message Navigator

PostgreSQL function in query [message #1807591]

Tue, 04 June 2019 09:59

Nicklas Karlsson

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:	DateTime Formatting not allowing modify for custom
Next Topic:	Split Value into rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 21 17:09:53 GMT 2019

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter