Re: [GENERAL] target list evaluation wrt sequences

2004-04-30 Thread Bruno Wolff III
On Fri, Apr 30, 2004 at 01:01:25 -0400, Tom Lane <[EMAIL PROTECTED]> wrote: > > Bruno Wolff III <[EMAIL PROTECTED]> writes: > > No. You can do effectively this by joining a select nextval to whatever > > you main select is. Something like: > > insert into ... > >select a.n as a, a.n as b

Re: [GENERAL] target list evaluation wrt sequences

2004-04-29 Thread Tom Lane
> elein <[EMAIL PROTECTED]> wrote: >> Is the order of the target list guaranteed? AFAIR, all current and past Postgres versions evaluate target lists left-to-right. This is not guaranteed to remain true forever, since neither the SQL spec nor our own docs promise it anywhere... but offhand I ca