postgres.git / summary / log / commit / refs

commit    d605eba0904b7c0cfe8c3d994df56fb9eaeb7989
Author:   Robert Haas <rhaas@postgresql.org>
Date:     Thu May 26 16:55:06 2022 +0000
First released in: 15.0, 10.22, 11.17, 12.12, 13.8, 14.4

    In CREATE FOREIGN TABLE syntax synopsis, fix partitioning stuff.
    
    Foreign tables can be partitioned, but previous documentation commits
    left the syntax synopsis both incomplete and incorrect.
    
    Justin Pryzby and Amit Langote
    
    Discussion: http://postgr.es/m/20220521130922.GX19626@telsasoft.com


 doc/src/sgml/ref/create_foreign_table.sgml | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml
index 8e9caabfe71..69bbee044a8 100644
--- a/doc/src/sgml/ref/create_foreign_table.sgml
+++ b/doc/src/sgml/ref/create_foreign_table.sgml
@@ -35,7 +35,8 @@ CREATE FOREIGN TABLE [ IF NOT EXISTS ] <replaceable class="PARAMETER">table_name
   { <replaceable class="PARAMETER">column_name</replaceable> [ WITH OPTIONS ] [ <replaceable class="PARAMETER">column_constraint</replaceable> [ ... ] ]
     | <replaceable>table_constraint</replaceable> }
     [, ... ]
-) ] <replaceable class="PARAMETER">partition_bound_spec</replaceable>
+) ]
+  FOR VALUES <replaceable class="parameter">partition_bound_spec</replaceable>
   SERVER <replaceable class="parameter">server_name</replaceable>
 [ OPTIONS ( <replaceable class="PARAMETER">option</replaceable> '<replaceable class="PARAMETER">value</replaceable>' [, ... ] ) ]
 
@@ -51,6 +52,12 @@ CREATE FOREIGN TABLE [ IF NOT EXISTS ] <replaceable class="PARAMETER">table_name
 
 [ CONSTRAINT <replaceable class="PARAMETER">constraint_name</replaceable> ]
 CHECK ( <replaceable class="PARAMETER">expression</replaceable> ) [ NO INHERIT ]
+
+<phrase>and <replaceable class="PARAMETER">partition_bound_spec</replaceable> is:</phrase>
+
+IN ( { <replaceable class="PARAMETER">numeric_literal</replaceable> | <replaceable class="PARAMETER">string_literal</replaceable> | TRUE | FALSE | NULL } [, ...] ) |
+FROM ( { <replaceable class="PARAMETER">numeric_literal</replaceable> | <replaceable class="PARAMETER">string_literal</replaceable> | TRUE | FALSE | MINVALUE | MAXVALUE } [, ...] )
+  TO ( { <replaceable class="PARAMETER">numeric_literal</replaceable> | <replaceable class="PARAMETER">string_literal</replaceable> | TRUE | FALSE | MINVALUE | MAXVALUE } [, ...] )
 </synopsis>
  </refsynopsisdiv>
 


[parent: 7686403b43ca]