| Unable to pass parameters when using Postgresql functions [message #506077] |
Tue, 05 January 2010 20:51  |
Eclipse User |
|
|
|
I have a BIRT report that runs on Pstgresql 8.3 queries. When I pass parameters to regular queries and set the parameters using the dataset editor, then there is no issue.
For example, select * from table where column = ? works just fine.
However, when I try to call a Postgresql function in the query and pass parameters to this function, I get an error.
For example , if I have a Postgresql function called get_dates(year integer)
and I call it in a report by saying:
select * from get_date(?)
This throws an error.
Can someome please tell me how to call postgresql functions in queries inside a BIRT report?
Many thanks!
|
|
|
| Re: Unable to pass parameters when using Postgresql functions [message #506244 is a reply to message #506077] |
Wed, 06 January 2010 11:34  |
| Eclipse User |
|
|
|
Does it work if you just call
select get_date(?)
or hard code the parameter?
Jason
Smitha wrote:
> I have a BIRT report that runs on Pstgresql 8.3 queries. When I pass
> parameters to regular queries and set the parameters using the dataset
> editor, then there is no issue. For example, select * from table where
> column = ? works just fine.
>
> However, when I try to call a Postgresql function in the query and pass
> parameters to this function, I get an error.
>
> For example , if I have a Postgresql function called get_dates(year
> integer)
> and I call it in a report by saying:
>
> select * from get_date(?)
>
> This throws an error.
>
> Can someome please tell me how to call postgresql functions in queries
> inside a BIRT report?
>
> Many thanks!
|
|
|
Powered by
FUDForum. Page generated in 0.03370 seconds
Home