Geometry RESTRICT and JOIN

Поиск
Список
Период
Сортировка
От Paul Matthews
Тема Geometry RESTRICT and JOIN
Дата
Msg-id 4A83CB70.9000006@netspace.net.au
обсуждение исходный текст
Ответы Re: Geometry RESTRICT and JOIN  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Hot standby and synchronous replication status
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Alpha 1 release notes