Re: LAST_INSERT_ID equivalent

On Thu, Jun 12, 2003 at 15:17:22 -0400,
  Erik Price <eprice@ptc.com> wrote:
> 
> So you're saying that you perform a pre-query to fetch the nextval, then 
> you include that in your query where you perform the INSERT?  I see. 
> Since this is all part of the same transaction, the nextval value won't 
> overwrite another simultaneous INSERT, I assume.  This seems like a good 
> way to do it too.  I don't mind the holes in the sequence, but wouldn't 
> this INSERT cause the sequence to increment the primary key yet again?

If you do things that way you specify a value for the serial column
rather than let it default to using nextval.