BUG #4809: Missing Expected Operator - Mailing list pgsql-bugs

From Paul Matthews
Subject BUG #4809: Missing Expected Operator
Date
Msg-id 200905151210.n4FCAEcO053885@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4809: Missing Expected Operator
List pgsql-bugs
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;

pgsql-bugs by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [HACKERS] Re: BUG #4796: Recovery followed by backup creates unrecoverable WAL-file
Next
From: Heikki Linnakangas
Date:
Subject: Re: [HACKERS] Re: BUG #4796: Recovery followed by backup creates unrecoverable WAL-file