Re: No ~ operator for box, point - Mailing list pgsql-hackers

From Tom Lane
Subject Re: No ~ operator for box, point
Date
Msg-id 15116.1169771194@sss.pgh.pa.us
Whole thread Raw
In response to Re: No ~ operator for box, point  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: No ~ operator for box, point  (Jim Nasby <jim@nasby.net>)
List pgsql-hackers
Martijn van Oosterhout <kleptog@svana.org> writes:
> On Thu, Jan 25, 2007 at 01:59:33PM -0500, Merlin Moncure wrote:
>> On 1/25/07, Jim C. Nasby <jim@nasby.net> wrote:
>>> decibel=# select box '((0,0),(2,2))' ~ point '(1,1)';
>>> ERROR:  operator does not exist: box ~ point
>>
>> I don't see a reason, although you can do it with polygon and not box.

Seems like an old oversight.

>> Also, I can't find the ~ operator defined for polygon in the
>> documentation, am I missing something?

~ is deprecated, "contains" is preferentially spelled @> now.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Proposal: Change of pg_trigger.tg_enabled and adding
Next
From: Jan Wieck
Date:
Subject: Re: Proposal: Commit timestamp