> I tried this:
>
> SET GENERATOR GEN_INVOICE_ID TO :A_RECYCLE_NO;
>
> but it won't accept it, stating that its a parsing error.

Hi,

you can't use SET GENERATOR in PSQL. Try the next instead:

A_RECYCLE_NO = GEN_ID(GEN_INVOICE_ID,A_RECYCLE_NO - GEN_ID(GEN_INVOICE_ID,0));

Regards

Kajtar Laszlo