Postgres Pro
Downloads
Home   >   mailing lists

How to obtain serial generate when doing an insert? - Mailing list pgsql-general

From Williams, Travis L, NPONS
Subject How to obtain serial generate when doing an insert?
Date
Msg-id AB815D267EC31A4693CC24D234F8291604AFF88A@ACCLUST02EVS1.ugd.att.com
Whole thread Raw
Responses Re: How to obtain serial generate when doing an insert?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
Tree view 
I have a table with a serial field, how can I obtain what serial was generated for the insert I'm doing?  I could just
doanother query for max(id) .. where id is my serial field.. but I'm worried another insert could have already came in. 

Travis

pgsql-general by date:

Previous
From: dan radom
Date:
Subject: Re: Postgresql on SUN Server
Next
From: Andrew Sullivan
Date:
Subject: Re: Postgresql on SUN Server