target list evaluation wrt sequences

Поиск
Список
Период
Сортировка
От elein
Тема target list evaluation wrt sequences
Дата
Msg-id 20040424160324.G1571@cookie.varlena.com
обсуждение исходный текст
Ответы Re: target list evaluation wrt sequences  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: target list evaluation wrt sequences  (Bruno Wolff III <bruno@wolff.to>)
Список 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@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.




В списке pgsql-general по дате отправления:

Предыдущее
От: Josué Maldonado
Дата:
Сообщение: Install plpython
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: target list evaluation wrt sequences