On Wed, Apr 20, 2011 at 09:27:18PM +0530, raghu ram wrote: > On Wed, Apr 20, 2011 at 9:21 PM, Emi Lu <em...@encs.concordia.ca> wrote: > > > Hello, > > > > ROW_NUMBER() is only ready in 8.4. For 8.3, is there a simple way to get > > row_number > > > > select row_number(), col1, col2... > > FROM tableName > > > > > > Below link will demonstrates ROW_NUMBER features in pre Postgresql-8.4:: > > http://www.postgresonline.com/journal/archives/79-Simulating-Row-Number-in-PostgreSQL-Pre-8.4.html
another approach: http://www.depesz.com/index.php/2007/08/17/rownum-anyone-cumulative-sum-in-one-query/ Best regards, depesz -- The best thing about modern society is how easy it is to avoid contact with it. http://depesz.com/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
