Geometry RESTRICT and JOIN

From: Paul Matthews <plm(at)netspace(dot)net(dot)au>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Geometry RESTRICT and JOIN
Date: 2009-08-13 08:14:40
Message-ID: 4A83CB70.9000006@netspace.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

CREATE OPERATOR << (
LEFTARG = box,
RIGHTARG = point,
PROCEDURE = leftof,
RESTRICT = scalarltsel, -- ?? UNSURE
JOIN = positionjoinsel -- ?? UNCLEAR
);

CREATE OPERATOR &> (
LEFTARG = box,
RIGHTARG = point,
PROCEDURE = notleft,
RESTRICT = scalargtsel, -- ?? UNSURE
JOIN = positionjoinsel -- ?? UNCLEAR
);

CREATE OPERATOR @> (
LEFTARG = box,
RIGHTARG = point,
PROCEDURE = contains,
RESTRICT = eqsel, -- ?? UNSURE
JOIN = contjoinsel -- ?? UNCLEAR
);

...etc...

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dimitri Fontaine 2009-08-13 08:31:54 Re: Alpha 1 release notes
Previous Message Greg Smith 2009-08-13 07:40:39 Re: Hot standby and synchronous replication status