Re: currval and nextval in 7.3.4

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.