Re: Geometry RESTRICT and JOIN

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Matthews <plm(at)netspace(dot)net(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Geometry RESTRICT and JOIN
Date: 2009-08-13 15:02:04
Message-ID: 7273.1250175724@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Paul Matthews <plm(at)netspace(dot)net(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-08-13 15:04:54 Re: Alpha 1 release notes
Previous Message Oleg Bartunov 2009-08-13 14:57:13 Re: Filtering dictionaries support and unaccent dictionary