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.