Re: target list evaluation wrt sequences

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: target list evaluation wrt sequences
Date: 2004-04-24 23:50:54
Message-ID: 20040424235053.GA12961@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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")

In response to

Browse pgsql-general by date

  From Date Subject
Next Message wespvp 2004-04-25 00:09:27 Re: thread_test.c problems
Previous Message elein 2004-04-24 23:03:24 target list evaluation wrt sequences