aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/select.sgml24
1 files changed, 24 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml
index f9f83f34f70..9a468b98c0a 100644
--- a/doc/src/sgml/ref/select.sgml
+++ b/doc/src/sgml/ref/select.sgml
@@ -654,6 +654,12 @@ GROUP BY <replaceable class="parameter">expression</replaceable> [, ...]
the grouped columns (or a subset thereof) are the primary key of
the table containing the ungrouped column.
</para>
+
+ <para>
+ Currently, <literal>FOR NO KEY UPDATE</>, <literal>FOR UPDATE</>,
+ <literal>FOR SHARE</> and <literal>FOR KEY SHARE</> cannot be
+ specified with <literal>GROUP BY</literal>.
+ </para>
</refsect2>
<refsect2 id="SQL-HAVING">
@@ -690,6 +696,12 @@ HAVING <replaceable class="parameter">condition</replaceable>
within aggregate functions. Such a query will emit a single row if the
<literal>HAVING</literal> condition is true, zero rows if it is not true.
</para>
+
+ <para>
+ Currently, <literal>FOR NO KEY UPDATE</>, <literal>FOR UPDATE</>,
+ <literal>FOR SHARE</> and <literal>FOR KEY SHARE</> cannot be
+ specified with <literal>HAVING</literal>.
+ </para>
</refsect2>
<refsect2 id="SQL-WINDOW">
@@ -825,6 +837,12 @@ UNBOUNDED FOLLOWING
</para>
<para>
+ Currently, <literal>FOR NO KEY UPDATE</>, <literal>FOR UPDATE</>,
+ <literal>FOR SHARE</> and <literal>FOR KEY SHARE</> cannot be
+ specified with <literal>WINDOW</literal>.
+ </para>
+
+ <para>
Window functions are described in detail in
<xref linkend="tutorial-window">,
<xref linkend="syntax-window-functions">, and
@@ -920,6 +938,12 @@ SELECT DISTINCT ON (location) location, time, report
will normally contain additional expression(s) that determine the
desired precedence of rows within each <literal>DISTINCT ON</> group.
</para>
+
+ <para>
+ Currently, <literal>FOR NO KEY UPDATE</>, <literal>FOR UPDATE</>,
+ <literal>FOR SHARE</> and <literal>FOR KEY SHARE</> cannot be
+ specified with <literal>DISTINCT</literal>.
+ </para>
</refsect2>
<refsect2 id="SQL-UNION">