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:36:01 -0400 |
| commit | e8b65986ba0de2daeb5bcedc02fb936b04fe464c (patch) | |
| tree | f67cc26ba2df7f00f988ce87de8dab0b6e186049 /doc/src/sgml/ref/create_table.sgml | |
| parent | f830183492d3a3b74cbd33645db19b8b5b5a2622 (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/sgml/ref/create_table.sgml')
| -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 a6ca5902499..9c63d927706 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -322,11 +322,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> @@ -1643,7 +1642,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 |