On Mon, 2003-03-24 at 22:50, Hiroshi Inoue wrote: > Does the SQL standard allow INSENSITIVE updatable cursors ?
Hmmm... apparently not: (Subsection 14.1, Syntax Rules of DECLARE CURSOR) 11) If an <updatability clause> of FOR UPDATE with or without a <column name list> is specified, then INSENSITIVE shall not be specified and QE shall be updateable. I'm not really sure I see the point of this restriction, though... Cheers, Neil ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org