From: Terry Yapt <pgsql@technovell.com>
To: pgsql-sql@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: rownum
Date: Mon, 17 Feb 2003 17:25:40 +0100
Message-ID: <3E510D04.5EEC1808@technovell.com> (raw)
References: <20030215045410.15935.qmail@web12707.mail.yahoo.com>
Perhaps you are using ROWNUM like LIMIT/OFFSET...
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=queries-limit.html
I hope this helps...
chester c young wrote:
>
> > 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.
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: pgsql@technovell.com, tgl@sss.pgh.pa.us
Subject: Re: rownum
In-Reply-To: <3E510D04.5EEC1808@technovell.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