Re: Line Numbering in SELRCT Output

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>