Skip site navigation (1) Skip section navigation (2)

target list evaluation wrt sequences

From: elein <elein(at)varlena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: elein <elein(at)varlena(dot)com>
Subject: target list evaluation wrt sequences
Date: 2004-04-24 23:03:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
I have an insert using a select of sequences.

insert into ...
		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?  

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

          PostgreSQL Consulting, Support & Training   

PostgreSQL General Bits
I have always depended on the [QA] of strangers.


pgsql-general by date

Next:From: Alvaro HerreraDate: 2004-04-24 23:50:54
Subject: Re: target list evaluation wrt sequences
Previous:From: Josué MaldonadoDate: 2004-04-24 19:38:13
Subject: Install plpython

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group