Commitc3db1f3

committed

doc: clarify PERIOD and WITHOUT OVERLAPS in CREATE TABLE

1 parentd727c54 commitc3db1f3Copy full SHA for c3db1f3

File tree

-5

lines changed

-5

lines changed

Lines changed: 7 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -1184,11 +1184,13 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM`
`1184`	`1184`	`referent for its entire duration. This column must be a range or`
`1185`	`1185`	`multirange type. In addition, the referenced table must have a primary`
`1186`	`1186`	`key or unique constraint declared with <literal>WITHOUT`
`1187`		`- OVERLAPS</literal>. Finally, if one side of the foreign key uses`
`1188`		`- <literal>PERIOD</literal>, the other side must too. If the <replaceable`
`1189`		`- class="parameter">refcolumn</replaceable> list is omitted, the`
`1190`		`- <literal>WITHOUT OVERLAPS</literal> part of the primary key is treated`
`1191`		`- as if marked with <literal>PERIOD</literal>.`
	`1187`	`+ OVERLAPS</literal>. Finally, if the foreign key has a PERIOD`
	`1188`	`+ <replaceable class="parameter">column_name</replaceable> specification`
	`1189`	`+ the corresponding <replaceable class="parameter">refcolumn</replaceable>,`
	`1190`	`+ if present, must also be marked <literal>PERIOD</literal>. If the`
	`1191`	`+ <replaceable class="parameter">refcolumn</replaceable> clause is omitted,`
	`1192`	`+ and thus the reftable's primary key constraint chosen, the primary key`
	`1193`	`+ must have its final column marked <literal>WITHOUT OVERLAPS</literal>.`
`1192`	`1194`	`</para>`
`1193`	`1195`
`1194`	`1196`	`<para>`

Comments

(0)