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@scw.org>
Director of Information Systems, Support Center of Washington