From: Tom Lane <tgl@sss.pgh.pa.us>
To: Joe Conway <mail@joeconway.com>
Cc: Richard Huxton <dev@archonet.com>
Cc: Josh Berkus <josh@agliodbs.com>
Cc: chester c young <chestercyoung@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: rownum
Date: Fri, 14 Feb 2003 11:21:04 -0500
Message-ID: <7746.1045239664@sss.pgh.pa.us> (raw)
In-Reply-To: <3E4D0E66.1030406@joeconway.com>
References: <20030214043800.99417.qmail@web12707.mail.yahoo.com>
<200302132056.20122.josh@agliodbs.com>
<4353.1045200034@sss.pgh.pa.us>
<200302141010.15271.dev@archonet.com>
<3E4D0E66.1030406@joeconway.com>
Joe Conway <mail@joeconway.com> writes:
> I've played with this a bit in the past, and concluded that the best way
> to do it (if in fact you agree it should be done at all), would be to
> add a rownum pseudo column as the results are projected from the backend
> to the frontend. I think this would require a change to the FE/BE
> protocol, which we've talked about doing for 7.4.
Considering that it can trivially be done on the client side, I think it
would be a hard sell to put such a wart into the protocol ...
regards, tom lane
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: tgl@sss.pgh.pa.us, mail@joeconway.com, dev@archonet.com, josh@agliodbs.com, chestercyoung@yahoo.com
Subject: Re: rownum
In-Reply-To: <7746.1045239664@sss.pgh.pa.us>
* 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