| From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
|---|---|
| To: | Alan Roberto Romaniuc <romaniuc(at)klais(dot)com(dot)br> |
| Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Sequence |
| Date: | 2003-01-12 00:24:43 |
| Message-ID: | 1042331083.2327.4.camel@inspiron.cramers |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
--
Dave Cramer <Dave(at)micro-automation(dot)net>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2003-01-12 00:28:11 | Re: Select * from users WHERE upper(lastName) = |
| Previous Message | Dave Cramer | 2003-01-12 00:01:33 | Re: persistent JDBC connections with a daemon |