[postgis-users] Operator precision

[Paul Ramsey]

Add an "AND" clause that tests containment of the point against a
rectangular polygon. Or that does explict ST_X(point) ST_Y(point)
against your box. There's no way to change the box2d behavior, and
it's a feature, not a bug (small boxes work better for large data
sets, and spatial index results are expected to be over-determined).

P.

On Mon, Feb 23, 2009 at 3:58 PM, Kemal Bayram <kemal at cins.co.uk> wrote:
> Hello all,
>
> I'm a using PostGIS working with mainly points testing against 2d bounded
> boxes, I recently came across a problem that is driving me nuts whereby:
>
> select makebox2d(makepoint(32.25, 34.9375), makepoint(32.31249, 35)) &&
> makepoint(32.3125, 34.996448);
>
> returns false (as expected), where as:
>
>
> select makebox2d(makepoint(32.25, 34.9375), makepoint(32.312499, 35)) &&
> makepoint(32.3125, 34.996448);
>
> returns true.
>
> 32.312499 cast as float4 is 32.3125, so I'm assuming that internally single
> precision is being used. Is there any way change this behaviour?
>
> Regards
> Kemal
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>