#263 One FETCH is necessary for UPDATE/DELETE WHERE CURRENT OF

[Abbas Butt]

In PG UPDATE/DELETE WHERE CURRENT OF work even if no row has been fetched from the cursor, in XC at least one FETCH is necessary.
This limitation is because of the way cursors are implemented in XC.

The test case involved here is portals.sql.

[Koichi Suzuki]

PG document says we need at least one fetch to WHERE CURRENT OF. In reality, PG allows WHERE CURRENT OF without fetching any.

May consider to write this explicitly in some of the documents.

[Koichi Suzuki]

This is specific notice for XC that application should FETCH first to update/delete WCO. Documentation update is required and leave this as XC specific.

Q3: would like to be included in the next minor release.