Re: target list evaluation wrt sequences - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: target list evaluation wrt sequences
Date
Msg-id 20040424235053.GA12961@dcc.uchile.cl
Whole thread Raw
In response to target list evaluation wrt sequences  (elein <elein@varlena.com>)
List pgsql-general
On Sat, Apr 24, 2004 at 04:03:24PM -0700, elein wrote:

> insert into ...
>     select
>         nextval('n') as a,
>         currval('n') as b,
>         ...
>     from lalala
> ;
>
> Is the order of the target list guaranteed?
> That is, will the a and b in the above selection
> *always* be the same?

No, it is not guaranteed to be the same.

PS: did you get my previous emails?  I sent #70 to you, and a lot of
questions ...

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Officer Krupke, what are we to do?
Gee, officer Krupke, Krup you! (West Side Story, "Gee, Officer Krupke")

pgsql-general by date:

Previous
From: elein
Date:
Subject: target list evaluation wrt sequences
Next
From:
Date:
Subject: Re: thread_test.c problems