Re: Geometry RESTRICT and JOIN - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Geometry RESTRICT and JOIN
Date
Msg-id 7273.1250175724@sss.pgh.pa.us
Whole thread Raw
In response to Geometry RESTRICT and JOIN  (Paul Matthews <plm@netspace.net.au>)
List pgsql-hackers
Paul Matthews <plm@netspace.net.au> writes:
> I'm trying to add all the "box op point" operators. The C routines are
> written and working as advertised. The manuals description of the
> RESTRICT and JOIN clauses of CREATE OPERATOR don't seem too clear. Are
> these samples correct, or am I totally off base here?

Well, I'm pretty sure you don't want the scalar selectivity functions
for any of these.  IIRC the geometric selectivity functions already
come in pairs, eg you should use contsel and contjoinsel for @>.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Filtering dictionaries support and unaccent dictionary
Next
From: Alvaro Herrera
Date:
Subject: Re: Alpha 1 release notes