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
|
|
|
Powered by
FUDForum. Page generated in 0.01941 seconds