diff options
| author | Robert Haas <rhaas@postgresql.org> | 2017-09-15 21:15:55 -0400 |
|---|---|---|
| committer | Robert Haas <rhaas@postgresql.org> | 2017-09-15 21:15:55 -0400 |
| commit | 9361f6f54e3ff9bab84e80d4b1e15be79b48d60e (patch) | |
| tree | e1e17babdceb4afef02a4b55eb43189e907cef96 /doc/src | |
| parent | c29145f00df2aa873672ab9f1b3fc4ec6a0ec05d (diff) | |
After a MINVALUE/MAXVALUE bound, allow only more of the same.
In the old syntax, which used UNBOUNDED, we had a similar restriction,
but commit d363d42bb9a4399a0207bd3b371c966e22e06bd3, which changed the
syntax, eliminated it. Put it back.
Patch by me, reviewed by Dean Rasheed.
Discussion: http://postgr.es/m/CA+Tgmobs+pLPC27tS3gOpEAxAffHrq5w509cvkwTf9pF6cWYbg@mail.gmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 11 |
1 files changed, 5 insertions, 6 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 824253de404..14772888519 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -324,11 +324,10 @@ FROM ( { <replaceable class="PARAMETER">numeric_literal</replaceable> | <replace </para> <para> - Note that any values after <literal>MINVALUE</> or - <literal>MAXVALUE</> in a partition bound are ignored; so the bound - <literal>(10, MINVALUE, 0)</> is equivalent to - <literal>(10, MINVALUE, 10)</> and <literal>(10, MINVALUE, MINVALUE)</> - and <literal>(10, MINVALUE, MAXVALUE)</>. + Note that if <literal>MINVALUE</> or <literal>MAXVALUE</> is used for + one column of a partitioning bound, the same value must be used for all + subsequent columns. For example, <literal>(10, MINVALUE, 0)</> is not + a valid bound; you should write <literal>(10, MINVALUE, MINVALUE)</>. </para> <para> @@ -1665,7 +1664,7 @@ CREATE TABLE measurement_y2016m07 <programlisting> CREATE TABLE measurement_ym_older PARTITION OF measurement_year_month - FOR VALUES FROM (MINVALUE, 0) TO (2016, 11); + FOR VALUES FROM (MINVALUE, MINVALUE) TO (2016, 11); CREATE TABLE measurement_ym_y2016m11 PARTITION OF measurement_year_month |