Re: [GENERAL] Adding auto-increment / sequence

2007-05-28 Thread A. Kretschmer
am Mon, dem 21.05.2007, um 18:29:46 -0700 mailte camb folgendes: > Hey all, > Is there any way to add some kind of sequence of auto-incrementing > column to the result set returned by a SELECT? Yes. You can use an sequence similar this: test=# select * from foo; col1 | col2 | col3 --+

[GENERAL] Adding auto-increment / sequence

2007-05-28 Thread camb
Hey all, Is there any way to add some kind of sequence of auto-incrementing column to the result set returned by a SELECT? I need to get an auto incrementing column of some kind into the result set from a view? Thanks in advance, Cam ---(end of broadcast)---