Paul Matthews wrote: > > The following bug has been logged online: > > Bug reference: 4809 > Logged by: Paul Matthews > Email address: p...@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 <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs