I have an insert using a select of sequences.
insert into ...
nextval('n') as a,
currval('n') as b,
Is the order of the target list guaranteed?
That is, will the a and b in the above selection
*always* be the same?
My experiments show this to be true, but I
would like to know that the evaluation of the
target list is never rearranged so that the
values are always predictable.
elein(at)varlena(dot)com Varlena, LLC www.varlena.com
PostgreSQL Consulting, Support & Training
PostgreSQL General Bits http://www.varlena.com/GeneralBits/
I have always depended on the [QA] of strangers.
pgsql-general by date
|Next:||From: Alvaro Herrera||Date: 2004-04-24 23:50:54|
|Subject: Re: target list evaluation wrt sequences|
|Previous:||From: Josué Maldonado||Date: 2004-04-24 19:38:13|
|Subject: Install plpython|