Re: rownum - Mailing list pgsql-sql

From Tom Lane
Subject Re: rownum
Date
Msg-id 7746.1045239664@sss.pgh.pa.us
Whole thread Raw
In response to Re: rownum  (Joe Conway <mail@joeconway.com>)
Responses Re: rownum  (chester c young <chestercyoung@yahoo.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: Passing arrays
Next
From: Jeff Boes
Date:
Subject: Timezone conversion