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 ...
> 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?
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