Re: updatable cursors and ORDER BY

On Wed, May 9, 2018 at 7:43 PM, Peter Eisentraut < peter.eisentr...@2ndquadrant.com> wrote: > The DECLARE reference page says: > > """ > Another reason to use FOR UPDATE is that without it, a subsequent WHERE > CURRENT OF might fail if the cursor query does not meet the SQL > standard's rules for

Re: updatable cursors and ORDER BY

Peter Eisentraut writes: > The DECLARE reference page says: > """ > Another reason to use FOR UPDATE is that without it, a subsequent WHERE > CURRENT OF might fail if the cursor query does not meet the SQL > standard's rules for being “simply updatable” (in

updatable cursors and ORDER BY

The DECLARE reference page says: """ Another reason to use FOR UPDATE is that without it, a subsequent WHERE CURRENT OF might fail if the cursor query does not meet the SQL standard's rules for being “simply updatable” (in particular, the cursor must reference just one table and not use grouping

\i and \ir separated by \if now...

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/app-psql.html Description: While I get that we want alphabetical order an exception for \i and \ir seems warranted; or maybe make \ir part of the \i meta command description -