From: Hubert Palme <hubert.palme@web.de>
To: pgsql-sql@postgresql.org
Subject: Re: Line Numbering in SELRCT Output
Date: Mon, 11 Mar 2002 23:55:04 +0100
Message-ID: <a6jck9$2be1$1@jupiter.hub.org> (raw)
References: <a6e70l$2o5p$1@jupiter.hub.org>
<a6fu9s$2t5h$1@jupiter.hub.org>
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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hubert.palme@web.de
Subject: Re: Line Numbering in SELRCT Output
In-Reply-To: <a6jck9$2be1$1@jupiter.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox