Re: BUG #4809: Missing Expected Operator

Paul Matthews wrote:
>
> The following bug has been logged online:
>
> Bug reference: 4809
> Logged by: Paul Matthews
> Email address: plm(at)netspace(dot)net(dot)au
> PostgreSQL version: 8.3.7
> Operating system: Linux OpenSuse 11.0
> Description: Missing Expected Operator
> Details:
>
> Not a bug as such, but an obvious operator is missing.
>
> WHERE
> g.box_boundary @> w.geocode and
> ERROR: operator does not exist: box @> point
> g.boundary @> w.geocode;
>
> This can be worked around with, the following, but it is really a kludge.
>
> WHERE
> g.box_boundary @> box( w.geocode, w.geocode ) and
> g.boundary @> w.geocode;

This is already mentioned on the TODO list:

Add missing operators for geometric data types

Some geometric types do not have the full suite of geometric
operators, e.g. box @> point

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

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