Re: temp sequence

2010/5/5 Sim Zacks <sim@compulab.co.il>:
> I am using 8.2.14
>
> I am trying to use a temp sequence in a function and I'm having a lot of
> trouble.
> I create the temp sequence and then I have to drop it at the end of the
> function, because it stays alive for the whole session and not just the
> function.
> I want to use the nextval function in an update statement so it gives a
> sequence number to each row it updates.
> If I drop the sequence and recreate it I get an OID not found error.
> I tried to run the update statement dynamically, but part of the update
> stmt is an int array variable and it won't cast it to text.
>
> My goal in the end is that every row that is updated will be numbered
> sequentially per update.
>
> Do you have any ideas?

Can you manipulate the sequence instead of dropping it?  i.e. select
setval('seqname',1); kind of thing?