On Thu, 23 Oct 2003, Keith Marr wrote:
> Hi,
>
> I recently installed 7.3.4 (complete install from scratch) and both 'select
> nextval('my_seq') from my_table' and 'select currval('my_seq') from my_table'
> return a number of rows equal to the number of rows in the table.
>
> The sequence was created with a SERIAL type if that helps.
> In 'psql' the results look like this.
>
> my_db=# select nextval('my_seq') from my_table;
> nextval
> ---------
> 6
> 7
> 8
> 9
> (4 rows)
This is what you asked for, for each row of my_table, call
nextval('my_seq') and return its value as an output row.
I'd guess that maybe you just want select nextval('myseq');
but I'm not sure.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
