Geometry RESTRICT and JOIN - Mailing list pgsql-hackers

From Paul Matthews
Subject Geometry RESTRICT and JOIN
Date
Msg-id 4A83CB70.9000006@netspace.net.au
Whole thread Raw
Responses Re: Geometry RESTRICT and JOIN  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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,     -- ??
UNSUREJOIN       = positionjoinsel  -- ?? UNCLEAR
 
);

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

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

...etc...



pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Hot standby and synchronous replication status
Next
From: Dimitri Fontaine
Date:
Subject: Re: Alpha 1 release notes