Re: Exclusion constraints on overlapping text arrays?

From: Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com>
To: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Exclusion constraints on overlapping text arrays?
Date: 2019-08-31 00:03:28
Message-ID: CAD3a31Ux1t315pZ1zLcs5ziZksZXv6+a3H9+VbPjFheiJD2+7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Aug 30, 2019 at 12:59 AM Achilleas Mantzios <
achill(at)matrix(dot)gatewaynet(dot)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
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Morris de Oryx 2019-08-31 02:46:12 Re: Aggregate functions on groups
Previous Message stan 2019-08-30 22:35:01 Re: How to get RAISE messges displayed?