Paul wrote:
> CREATE SEQUENCE seq1;
>
> SELECT nextval('seq1'), amname FROM pg_am;
>
> DROP SEQUENCE seq1;
>
Hmm... I forgot to mention that my SELECT statement has an ORDER BY clause.
The sort is done after the sequence numbers being generated. So the order
of the sequence numbers becomes damaged by the sort.
Is there any hint how to avoid this?
--
Hubert Palme Am Walde 1 42119 Wuppertal
<hubert.palme@web.de>