Re: [ADMIN] plpgsql syntax question

2010-08-30 Thread Mark Rostron
> That syntax is fine ... in 8.4 and up. I think you are trying to use some > older server version, and not reading the right version of the manual. Thanks Mr Lane Yes - I was testing it on 8.3.10, but the manual was 8.4.2 :( -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)

Re: [ADMIN] plpgsql syntax question

2010-08-30 Thread Tom Lane
Mark Rostron writes: > Ok guys - there is something here that I am not seeing Can someone > please set me straight. > I am trying to create a cursor loop with an "update where current of " > statement, but my syntax is wrong. That syntax is fine ... in 8.4 and up. I think you are trying t

[ADMIN] plpgsql syntax question

2010-08-30 Thread Mark Rostron
Ok guys - there is something here that I am not seeing Can someone please set me straight. I am trying to create a cursor loop with an "update where current of " statement, but my syntax is wrong. Would one of you be able to tell me what I'm doing. Also: adding "for update" to the curs1 curs