| From: | Joel Burton <jburton(at)scw(dot)org> |
|---|---|
| To: | Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
| Cc: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk>, Koen Antonissen <Koen(at)Cee-Kay(dot)net>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: enumerating rows |
| Date: | 2001-04-11 21:53:19 |
| Message-ID: | Pine.LNX.4.21.0104111752330.15117-100000@olympus.scw.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, 11 Apr 2001, Kovacs Zoltan wrote:
> > 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?
If you don't need the numbers in PostgreSQL, but in the output, could you
pipe your query results through `cat -b`, which will add line numbers?
--
Joel Burton <jburton(at)scw(dot)org>
Director of Information Systems, Support Center of Washington
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Diehl, Jeffrey | 2001-04-11 23:02:06 | DB porting questions... |
| Previous Message | Oliver Elphick | 2001-04-11 20:08:26 | Re: enumerating rows |