| 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: | 20040424160324.G1571@cookie.varlena.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2004-04-24 23:50:54 | Re: target list evaluation wrt sequences |
| Previous Message | Josué Maldonado | 2004-04-24 19:38:13 | Install plpython |