Re: enumerating rows - Mailing list pgsql-sql

From Kovacs Zoltan
Subject Re: enumerating rows
Date
Msg-id Pine.LNX.4.21.0104111841120.3975-100000@pc10.radnoti-szeged.sulinet.hu
Whole thread Raw
In response to Re: enumerating rows  ("Oliver Elphick" <olly@lfix.co.uk>)
Responses Re: enumerating rows
Re: enumerating rows
Re: enumerating rows
List pgsql-sql
> Here is a method which is fairly cumbersome, but will do what you want.
> (Whether what you want is useful, is another matter.  The row numbers
> have no meaning except to delineate which row is printed after which; they
> bear no relation to their order in the table.)
Thanks, Oliver! Are you sure there is no other (more
convenient) solution? I don't think this is a part of the SQL standard but
it could be a PostgreSQL extension. Hm?

Regards, Zoltan



pgsql-sql by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: enumerating rows
Next
From: "Gerald Gutierrez"
Date:
Subject: Making SELECT COUNT(seed) FROM fast