Jose,
Postgres is slightly different than most databases in it's implementation of functions. What you need to do is put the function in a select as follows:
there is a builtin function called nextval('sequence') so you can "call" nextval like this
select nextval('sequence_name')
Note: the single quotes are necessary and it will return a column nextval in the resultset.
Dave
Hello,
Can anybody help me? How can I pass values to a plpgsql functions from jdbc. I have tried the CallableStatement but this seems not to be implemented (Using Postgresql 7.2). Is there any way of passing the values via Statement or PreparedStatement. If this is not possible could someone tell me where I can find some examples doing this via the FastPath Api.
Thanks and best regards
Jose Luis