On 5/5/2010 2:36 AM, Sim Zacks wrote:
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? Sim
Perhaps you can rewrite to use generate_series instead? http://www.postgresql.org/docs/8.0/interactive/functions-srf.html -Andy -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
