pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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>



view thread (5+ messages)  latest in thread

Message-ID: <a6jck9$2be1$1@jupiter.hub.org>
Permalink:  ../a6jck9$2be1$1@jupiter.hub.org/
Also on:    postgresql.org/message-id/a6jck9$2be1$1@jupiter.hub.org

 · 

reply

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