On Sat, Apr 24, 2004 at 16:03:24 -0700,
elein <elein(at)varlena(dot)com> wrote:
> I have an insert using a select of sequences.
> insert into ...
> 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?
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, ....
from (select nextval('n') as n) as a, lalala
In response to
pgsql-general by date
|Next:||From: Bruce Momjian||Date: 2004-04-25 13:57:07|
|Subject: Re: thread_test.c problems|
|Previous:||From: Bruno Wolff III||Date: 2004-04-25 10:59:30|
|Subject: Re: Install plpython|