Re: rownum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: Richard Huxton <dev(at)archonet(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, chester c young <chestercyoung(at)yahoo(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: rownum
Date: 2003-02-14 16:21:04
Message-ID: 7746.1045239664@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Joe Conway <mail(at)joeconway(dot)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

In response to

  • Re: rownum at 2003-02-14 15:42:30 from Joe Conway

Responses

  • Re: rownum at 2003-02-15 04:54:10 from chester c young

Browse pgsql-sql by date

  From Date Subject
Next Message Tambet Matiisen 2003-02-14 16:25:02 Re: PL/PGSQL EDITOR
Previous Message Joe Conway 2003-02-14 15:48:20 Re: [SQL] Passing arrays