target list evaluation wrt sequences
От | elein |
---|---|
Тема | target list evaluation wrt sequences |
Дата | |
Msg-id | 20040424160324.G1571@cookie.varlena.com обсуждение исходный текст |
Ответы |
Re: target list evaluation wrt sequences
Re: target list evaluation wrt sequences |
Список | 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 по дате отправления: