BUG #4809: Missing Expected Operator
The following bug has been logged online:
Bug reference: 4809
Logged by: Paul Matthews
Email address: plm@netspace.net.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;
Paul Matthews wrote:
The following bug has been logged online:
Bug reference: 4809
Logged by: Paul Matthews
Email address: plm@netspace.net.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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +