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 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? > > > > ---------------------------------------------------------------------- > > ----- > > > > 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, 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 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 [EMAIL PROTECTED] > >> 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 [EMAIL PROTECTED] > > EnterpriseDB http://www.enterprisedb.com > > > > + If your life is a hard drive, Christ can be your backup. + > > > > -- > Jim Nasby [EMAIL PROTECTED] > EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings