From: chester c young <chestercyoung@yahoo.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: rownum
Date: Fri, 14 Feb 2003 20:54:10 -0800 (PST)
Message-ID: <20030215045410.15935.qmail@web12707.mail.yahoo.com> (raw)
In-Reply-To: <7746.1045239664@sss.pgh.pa.us>
> 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 ...
having used Oracle for many years, I cannot think of a project in which
I did not use rownum, including within procedures and triggers and
subqueries. can usually be easily done - loop within loop - but more
easily and bugfree as column within select.
by "wart" do you mean aesthetically or code-wise? naively, it seems
like pg is already keeping a row counter to implement limit.
__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
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: chestercyoung@yahoo.com, tgl@sss.pgh.pa.us
Subject: Re: rownum
In-Reply-To: <20030215045410.15935.qmail@web12707.mail.yahoo.com>
* 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