Re: No ~ operator for box, point

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Jim Nasby <jim(at)nasby(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: No ~ operator for box, point
Date: 2007-01-27 02:32:11
Message-ID: 200701270232.l0R2WB227101@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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(at)svana(dot)org> writes:
> >> On Thu, Jan 25, 2007 at 01:59:33PM -0500, Merlin Moncure wrote:
> >>> On 1/25/07, Jim C. Nasby <jim(at)nasby(dot)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.
>
> Ok. If I ever get some time I'll submit a patch to bring everything
> in-line (there's other missing operators as well).
>
> >>> Also, I can't find the ~ operator defined for polygon in the
> >>> documentation, am I missing something?
> >
> > ~ is deprecated, "contains" is preferentially spelled @> now.
>
> Ok, I'll keep that in mind.
> --
> Jim Nasby jim(at)nasby(dot)net
> EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-01-27 02:33:38 Re: BUG #2917: spi_prepare doesn't accept typename
Previous Message Bruce Momjian 2007-01-27 02:29:57 Re: Piggybacking vacuum I/O