CREATE SEQUENCE seq1;
SELECT nextval('seq1'), amname FROM pg_am;
DROP SEQUENCE seq1;
"Hubert Palme" <hubert.palme@web.de> wrote in message
news:a6e70l$2o5p$1@jupiter.hub.org...
> Hi,
>
> how can I get line numbers in the output of a select statement, e.g.
>
> No. | Name | ...
> -----+------------------+-------
> 1 | Meyer | ...
> 2 | Miller | ...
> 3 | Mueller | ...
> 4 | Smith | ...
>
> Thanks in advance,
> --
> Hubert Palme Am Walde 1
> 42119 Wuppertal
> <hubert.palme@web.de>