Re: how to show serial number of record

am  Thu, dem 18.01.2007, um 15:34:33 +0530 mailte deepak pal folgendes:
> hi i want to add a coloum called serial numer in my record set how could i do
> it..that column is not in table.

Do you mean something like this:?

test=# create table foo (t text);
CREATE TABLE
test=*# insert into foo values ('foo');
INSERT 0 1
test=*# insert into foo values ('bar');
INSERT 0 1
test=*# insert into foo values ('batz');
INSERT 0 1
test=*# select * from foo;
  t
------
 foo
 bar
 batz
(3 rows)

test=*# create sequence foo_seq;
CREATE SEQUENCE
test=*# select nextval('foo_seq'), * from foo;
 nextval |  t
---------+------
       1 | foo
       2 | bar
       3 | batz
(3 rows)


Of course, you can rename the first column using the 'as' - syntax.



Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net