X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AD72B475AEC for ; Fri, 14 Feb 2003 11:21:16 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id F31C5475A9E for ; Fri, 14 Feb 2003 11:21:15 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.6/8.12.6) with ESMTP id h1EGL55u007747; Fri, 14 Feb 2003 11:21:05 -0500 (EST) To: Joe Conway Cc: Richard Huxton , Josh Berkus , chester c young , pgsql-sql@postgresql.org Subject: Re: rownum In-reply-to: <3E4D0E66.1030406@joeconway.com> References: <20030214043800.99417.qmail@web12707.mail.yahoo.com> <200302132056.20122.josh@agliodbs.com> <4353.1045200034@sss.pgh.pa.us> <200302141010.15271.dev@archonet.com> <3E4D0E66.1030406@joeconway.com> Comments: In-reply-to Joe Conway message dated "Fri, 14 Feb 2003 07:42:30 -0800" Date: Fri, 14 Feb 2003 11:21:04 -0500 Message-ID: <7746.1045239664@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/334 X-Sequence-Number: 11732 Joe Conway 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