Re: enumerating rows

From: Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: Koen Antonissen <Koen(at)Cee-Kay(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: enumerating rows
Date: 2001-04-11 16:43:35
Message-ID: Pine.LNX.4.21.0104111841120.3975-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oliver Elphick 2001-04-11 16:46:22 Re: enumerating rows
Previous Message Hans-Jürgen Schönig 2001-04-11 16:29:04 Dropping users with no name