Re: Exclude constraint using custom operator

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tobia Conforto <tobia(dot)conforto(at)gruppo4(dot)eu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Exclude constraint using custom operator
Date: 2016-04-06 13:50:08
Message-ID: 28543.1459950608@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tobia Conforto <tobia(dot)conforto(at)gruppo4(dot)eu> writes:
> Stated differently, is there a simple way to extend or "subclass" the builtin range_ops operator family, adding my own operator to it, so that I can use it in an exclude index?

No. In a GIST opclass, the set of supported operator strategies is
determined by the code in the opclass support functions (primarily,
what the "consistent" function knows how to do). You'd have to go
fiddle with that C code before you could add a new operator to the
opclass.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-04-06 13:50:16 Re: what database schema version management system to use?
Previous Message Achilleas Mantzios 2016-04-06 11:34:01 Re: what database schema version management system to use?