Re: Typo in doc or wrong EXCLUDE implementation

2018-08-10 Thread KES
; Bruce Momjian writes: >>  On Thu, Aug 9, 2018 at 01:11:05PM +0300, KES wrote: >>>  Why surprising? It is >>>  [documented](https://www.postgresql.org/docs/current/static/sql-create >>>  table.html#sql-createtable-exclude): >>>>  If all of the specifi

Re: Typo in doc or wrong EXCLUDE implementation

2018-08-09 Thread KES
s: >>  On Wed, Aug 8, 2018 at 01:55:53PM +0300, KES wrote: >>>  If such exclusion constraint would be marked as UNIQUE we can use it for >>> FK while implementing temporal/bi-temporal tables. > >>  Yes, it would work, but doing that only for equality would be

Re: Typo in doc or wrong EXCLUDE implementation

2018-08-08 Thread KES
I do not know many internals and maybe wrong. But from my point of view with my current knowledge. If such exclusion constraint would be marked as UNIQUE we can use it for FK while implementing temporal/bi-temporal tables. And this will be simplify relationing while implementing them. 07.08.20