[postgis-users] st_within maddness

Paul Ramsey pramsey at cleverelephant.ca
Fri Jul 24 07:48:20 PDT 2009


If you flip the order of arguments and use st_contains() instead, does
that work? I vaguely remember a bug in the bounds-check short-circuit
of within that was fixed a while ago...

P.

On Fri, Jul 24, 2009 at 7:46 AM, Kevin Galligan<kg at kagii.com> wrote:
> Might I ask where you get the definition of srid '900913'?  I know I
> had to insert that myself from something I found on the web.  I'm
> shooting in the dark here, but that's another possible variable in the
> mix.
>
> On Fri, Jul 24, 2009 at 10:18 AM, Maxime van Noppen<maxime at altribe.org> wrote:
>> On 07/24/09 15:49, Kevin Galligan wrote:
>>> I'm sure there's something simple I'm missing here, but we've hit the
>>> "pull hair out" stage, so I'm hoping there's a kind soul out there
>>> that can clear things up.
>>
>> I've ran the example you give that you give as example and get results :
>>
>>> # select asewkt(bbox) from testwithin where st_within(bbox, ST_Buffer(ST_SetSRID(ST_MakePoint(-8232000, 4980000),900913), 500));
>>>                                                    asewkt
>>> -------------------------------------------------------------------------------------------------------------
>>>  SRID=900913;POLYGON((-8232000 4980000,-8232000 4980100,-8231900 4980100,-8231900 4980000,-8232000 4980000))
>>
>> No idea what the problem can be though :-/
>>
>> --
>> yabo
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>
>
>
> --
> --------------------
> Kevin Galligan
> www.kagii.com
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list