Eclipse Community Forums: BIRT » PostgreSQL function in query

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

PostgreSQL function in query [message #1807591]

Tue, 04 June 2019 05:59

Eclipse User

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 06:37] by Moderator

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

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 12 14:10:00 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter