Re: [HACKERS] order by in cursor declaration does not allow update

[Tom Lane]

"Dharmendra Goyal" <[EMAIL PROTECTED]> writes:
> If a cursor is declared using "Order by" then it gives following error
> during updation of the cursor:
> ERROR:  cursor "c" is not a simply updatable scan of table "test"

This is not a bug.  (See also quote from SQL92 in the other thread.)

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster