Search Postgresql Archives

target list evaluation wrt sequences

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I have an insert using a select of sequences.

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?  

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.

Thanks,

elein
============================================================
elein@varlena.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.




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux