Tony Reina wrote, On 4/10/2004 18:12:
Simple question:
Is there a function that will allow me to number the returned tuples?
e.g.
CREATE TABLE test ( field1 text ):
INSERT INTO test VALUES ('first'); INSERT INTO test VALUES ('second'); INSERT INTO test VALUES ('third'); INSERT INTO test VALUES ('fourth');
SELECT number(), field1 FROM test;
1 'first' 2 'second' 3 'third' 4 'fourth'
where number() is the function I'm trying to find out about.
a simple way:
create temporary sequence st;
select nextval('st'),field1 from test;
drop sequence st;C.
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
