Re: How do I setup this Exclusion Constraint? - Mailing list pgsql-general

From Richard Broersma
Subject Re: How do I setup this Exclusion Constraint?
Date
Msg-id CABvLTWFhW2Ke2DXjLPhFYa9ozQgN3i0HUpWfeNh8ADcJpcJ44w@mail.gmail.com
Whole thread Raw
In response to How do I setup this Exclusion Constraint?  (bradford <fingermark@gmail.com>)
Responses Re: How do I setup this Exclusion Constraint?
List pgsql-general
On Tue, May 1, 2012 at 10:15 AM, bradford <fingermark@gmail.com> wrote:
> I'm trying to used what I learned in
> http://www.depesz.com/2010/01/03/waiting-for-8-5-exclusion-constraints/,
> but I cannot figure out how to apply this exclusion constraint to col1
> (integer) + col2 (varchar).

Take a look at Btree_gist index:
http://www.postgresql.org/docs/9.1/static/btree-gist.html

I think this is the part that your missing.


--
Regards,
Richard Broersma Jr.

pgsql-general by date:

Previous
From: bradford
Date:
Subject: How do I setup this Exclusion Constraint?
Next
From: bradford
Date:
Subject: Re: How do I setup this Exclusion Constraint?