Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using advance update

Using advance update

From
"Yudha Setiawan"
Date:
Dear Milist,
Somebody please give me more explanation about
using "Update" syntax with cursor. I've seen this
on manual of postgre(sql-update.html). Here it is
the example;
 
    UPDATE table SET column = expression [, ...]
           WHERE CURRENT OF cursor
 
But there's no further clearly explanation or the
sample of usages. Somebody please give me ones.
 
Thank's and GOD Bless You.   
 
Yudha Setiawan.
VoIP
    No.        : 01119311223344

Re: Using advance update

From
Tom Lane
Date:
"Yudha Setiawan" <yudha@BonBon.net> writes:
> Somebody please give me more explanation about=20
> using "Update" syntax with cursor. I've seen this
> on manual of postgre(sql-update.html). Here it is
> the example;

>     UPDATE table SET column =3D expression [, ...]
>            WHERE CURRENT OF cursor

Did you not understand that the manual page is saying we don't support that?

            regards, tom lane