Re: getting back autonumber just inserted - Mailing list pgsql-sql

From Larry Meadors
Subject Re: getting back autonumber just inserted
Date
Msg-id a10a823c0507071909514c815b@mail.gmail.com
Whole thread Raw
In response to Re: getting back autonumber just inserted  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Sounds like M$ SuckQL's @@identity value. ;-)

Larry

On 7/7/05, Michael Fuhr <mike@fuhr.org> wrote:
> On Fri, Jul 08, 2005 at 01:56:26AM +0200, PFC wrote:
> > >Do you mean with lastval()?  Here's what happens:
> >
> > Hm, interesting, you mean the return value of lastval() also depends
> > if  you set your constraints  to deferred or immediate ?
>
> My mind's ablank trying to contrive a situation where that would
> matter.  Can you provide an example?
>
> In any case, I simply meant to point out that 8.1's lastval() will
> be seductively convenient because you don't have to pass it a
> sequence name, but the value it returns might not be the value you
> want.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>


pgsql-sql by date:

Previous
From: Frank Hagstrom
Date:
Subject: Possible to use a table to tell what table to select from?
Next
From: Larry Meadors
Date:
Subject: Re: getting back autonumber just inserted