]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Forbid FOR PORTION OF with WHERE CURRENT OF
authorPeter Eisentraut <peter@eisentraut.org>
Mon, 29 Jun 2026 13:13:45 +0000 (15:13 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Mon, 29 Jun 2026 13:17:10 +0000 (15:17 +0200)
commitbc3ae886a759f2d3fd5f1b92f5fbeeccfee9e7a9
treeeed42353543f57ff6f3051d308d5df77c0a6126d
parent994f770a0fd55dfdeb96d1d60d35545ba2d51480
Forbid FOR PORTION OF with WHERE CURRENT OF

It is not clear how the implicit condition of FOR PORTION OF should
interact with the use of a cursor.  Normally, we forbid combining
WHERE CURRENT OF with other WHERE conditions.  The SQL standard only
includes FOR PORTION OF with <update statement: searched> and <delete
statement: searched>, not <update statement: positioned> or <delete
statement: positioned>, so it is easy for us to exclude the
functionality, at least for now.

Author: Paul A. Jungwirth <pj@illuminatedcomputing.com>
Discussion: https://www.postgresql.org/message-id/flat/CA%2BrenyUEKPexUYsH4qeU8_o1jqKsUkEWca1keS6n21shgG1g%2BA%40mail.gmail.com
doc/src/sgml/ref/delete.sgml
doc/src/sgml/ref/update.sgml
src/backend/parser/analyze.c
src/test/regress/expected/for_portion_of.out
src/test/regress/sql/for_portion_of.sql