Re: Line Numbering in SELRCT Output - Mailing list pgsql-sql

On Mon, 11 Mar 2002, Hubert Palme wrote:

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

select nextval('seq1'), foo.* from (select ...) foo;