Postgres Pro
Downloads
Home   >   mailing lists

Re: Typo in doc or wrong EXCLUDE implementation - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Typo in doc or wrong EXCLUDE implementation
Date
Msg-id 20180808130040.GA2611@momjian.us
Whole thread Raw
In response to Re: Typo in doc or wrong EXCLUDE implementation  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Typo in doc or wrong EXCLUDE implementation
List pgsql-hackers
Tree view 
On Wed, Aug  8, 2018 at 01:55:53PM +0300, KES wrote:
> 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.

Yes, it would work, but doing that only for equality would be surprising
to many people because exclusion constraints are more general than
equality comparisons.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [PATCH] Improve geometric types
Next
From: Stephen Frost
Date:
Subject: Re: Negotiating the SCRAM channel binding type