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

Reply via email to