diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 68309ba..2ea3db7 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -607,6 +607,12 @@ GROUP BY expression [, ...] the grouped columns (or a subset thereof) are the primary key of the table containing the ungrouped column. + + + Currently, FOR NO KEY UPDATE, FOR UPDATE, + FOR SHARE and FOR KEY SHARE cannot be + specified with GROUP BY. + @@ -643,6 +649,12 @@ HAVING condition within aggregate functions. Such a query will emit a single row if the HAVING condition is true, zero rows if it is not true. + + + Currently, FOR NO KEY UPDATE, FOR UPDATE, + FOR SHARE and FOR KEY SHARE cannot be + specified with HAVING. + @@ -778,6 +790,12 @@ UNBOUNDED FOLLOWING + Currently, FOR NO KEY UPDATE, FOR UPDATE, + FOR SHARE and FOR KEY SHARE cannot be + specified with WINDOW. + + + Window functions are described in detail in , , and @@ -873,6 +891,12 @@ SELECT DISTINCT ON (location) location, time, report will normally contain additional expression(s) that determine the desired precedence of rows within each DISTINCT ON group. + + + Currently, FOR NO KEY UPDATE, FOR UPDATE, + FOR SHARE and FOR KEY SHARE cannot be + specified with DISTINCT. +