Re: Sequence - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Sequence
Date
Msg-id 1042331083.2327.4.camel@inspiron.cramers
Whole thread Raw
In response to Sequence  (Alan Roberto Romaniuc <romaniuc@klais.com.br>)
Responses Re: Sequence  (Simon Mitchell <pgsql@jseb.com>)
List pgsql-jdbc
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>


pgsql-jdbc by date:

Previous
From: "Hale Pringle"
Date:
Subject: Select * from users WHERE upper(lastName) = upper('Pringle')
Next
From: Dave Cramer
Date:
Subject: Re: Select * from users WHERE upper(lastName) =