> 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)
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
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