Postgres Pro
Downloads
Home   >   mailing lists

Re: Exclusion constraints on overlapping text arrays? - Mailing list pgsql-general

From Ken Tanzer
Subject Re: Exclusion constraints on overlapping text arrays?
Date
Msg-id CAD3a31Ux1t315pZ1zLcs5ziZksZXv6+a3H9+VbPjFheiJD2+7w@mail.gmail.com
Whole thread Raw
In response to Re: Exclusion constraints on overlapping text arrays?  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
List pgsql-general
Tree view
On Fri, Aug 30, 2019 at 12:59 AM Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
On 30/8/19 10:20 π.μ., Achilleas Mantzios wrote:
Maybe take a look at https://dba.stackexchange.com/questions/185174/error-data-type-text-has-no-default-operator-class-for-access-method-gist

So you download latest version of smlar from here : http://sigaev.ru/git/gitweb.cgi?p=smlar.git
following is from commands given to FreeBSD but you get the point


Well I set this up on a test machine running 11.4, and it certainly seems to do what it's supposed to.  Pretty cool, and thanks for pointing this out!

Is there much or any prospect of this becoming a supported extension?

And Tom--thanks for the pointer on the parentheses!

Cheers,
Ken

 
--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

pgsql-general by date:

Previous
From: stan
Date:
Subject: Re: How to get RAISE messges displayed?
Next
From: Morris de Oryx
Date:
Subject: Re: Aggregate functions on groups