Alan,
You can't, get the sequence before and insert it.
Dave
On Thu, 2003-01-09 at 14:35, Alan Roberto Romaniuc wrote:
> I have a table with sequence field (id).
>
> I insert a new row in this table, and I would like to get the sequence
> number that postgresql assign to id.
>
> How can I get it??? ... Max function is not nice.......
>
> jdbc2 ....
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
--
Dave Cramer <Dave@micro-automation.net>