Powerbuilder and postgresql sequence problem

[11shanu]

Hi,
We have an application written in powerbuilder with oracle database. Now we have moved to Postgres instead of oracle so we had to make few changes in our sql queries. But in the sequence there is this problem:
In oracle it was ..
SELECT "sqorgid".NEXTVAL
INTO :ll_org_id
from dual
USING sqlca ;

But in postgres there is no need for dual and query should be in this form..
SELECT NEXTVAL('sqorgid')
INTO :ll_org_id
USING sqlca ;

but it is giving error in powerbuilder, it seems like powerbuilder needs 'from' clause.
Please tell me how to modify this select stmt so that it work in the powerbuilder.

Thanks

 

[ceco]

i haven't used powerbuilder if it is oracle specific tool it is normal to have problems ;-)

if you use it in plpgsql function you can try the alternative syntax

temp := nextval(''r_test_id_seq'');

what do you use :ll_org_id for? I can't recognize it as postgre feature

also in postgre this usage of USING is also a problem