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

From Merlin Moncure
Subject Re: No ~ operator for box, point
Date
Msg-id b42b73150701251059x31559218ndbd038ca5a68b801@mail.gmail.com
Whole thread Raw
In response to No ~ operator for box, point  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: No ~ operator for box, point
List pgsql-hackers
On 1/25/07, Jim C. Nasby <jim@nasby.net> wrote:
> decibel=# select version();
>  PostgreSQL 8.3devel on i386-apple-darwin8.8.2, compiled by GCC i686-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple
Computer,Inc. build 5363)
 
>
> decibel=# select box '((0,0),(2,2))' ~ point '(1,1)';
> ERROR:  operator does not exist: box ~ point
> LINE 1: select box '((0,0),(2,2))' ~ point '(1,1)';

I don't see a reason, although you can do it with polygon and not box.Also, I can't find the ~ operator defined for
polygonin the
 
documentation, am I missing something?

merlin


pgsql-hackers by date:

Previous
From: "Simon Riggs"
Date:
Subject: Implied Functional index use (redux)
Next
From: Andrew Dunstan
Date:
Subject: BUG #2917: spi_prepare doesn't accept typename aliases such as 'integer'