Re: [HACKERS] No ~ operator for box, point

2007-02-27 Thread Jim C. Nasby
On Tue, Feb 20, 2007 at 04:22:27PM -0500, Bruce Momjian wrote: Added to TODO: * Add missing operators for geometric data types Some geometric types do not have the full suite of geometric operators, e.g. box @ point I've started looking at this, and ISTM

Re: [HACKERS] No ~ operator for box, point

2007-02-27 Thread Tom Lane
Jim C. Nasby [EMAIL PROTECTED] writes: Is there any reason not to make these casts implicit? To the extent that you're trying to provide operators that should be indexable, that won't solve the problem. I'm unconvinced that these casts should be implicit anyway, as the types are really

Re: [HACKERS] No ~ operator for box, point

2007-02-20 Thread Bruce Momjian
Added to TODO: * Add missing operators for geometric data types Some geometric types do not have the full suite of geometric operators, e.g. box @ point --- Jim Nasby wrote: * Add

Re: [HACKERS] No ~ operator for box, point

2007-01-29 Thread Jim Nasby
* Add missing operators for geometric data types and operators There are geometric data types that do not have the full suite of geometric operators defined; for example, box @ point does not exist. On Jan 26, 2007, at 9:32 PM, Bruce Momjian wrote: Can I get a TODO on this?

Re: [HACKERS] No ~ operator for box, point

2007-01-26 Thread Jim Nasby
On Jan 25, 2007, at 6:26 PM, Tom Lane wrote: 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 [EMAIL PROTECTED] wrote: decibel=# select box '((0,0),(2,2))' ~ point '(1,1)'; ERROR: operator does not

Re: [HACKERS] No ~ operator for box, point

2007-01-26 Thread Bruce Momjian
Can I get a TODO on this? --- Jim Nasby wrote: On Jan 25, 2007, at 6:26 PM, Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: On Thu, Jan 25, 2007 at 01:59:33PM -0500, Merlin Moncure wrote: On 1/25/07,

[HACKERS] No ~ operator for box, point

2007-01-25 Thread Jim C. Nasby
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

Re: [HACKERS] No ~ operator for box, point

2007-01-25 Thread Merlin Moncure
On 1/25/07, Jim C. Nasby [EMAIL PROTECTED] 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

Re: [HACKERS] No ~ operator for box, point

2007-01-25 Thread Martijn van Oosterhout
On Thu, Jan 25, 2007 at 01:59:33PM -0500, Merlin Moncure wrote: On 1/25/07, Jim C. Nasby [EMAIL PROTECTED] 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)

Re: [HACKERS] No ~ operator for box, point

2007-01-25 Thread Tom Lane
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 [EMAIL PROTECTED] 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