[postgis-users] Problem with ST_intersects

[James Sewell]

Sorry, I forgot to say I have encountered the problem with the following versions / OSes

 CentOS: POSTGIS="1.5.2" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23 September 2009 " LIBXML="2.6.26" USE_STATS

 Solaris: POSTGIS="1.5.2" GEOS="3.1.1-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.6.31" USE_STATS

----
James Sewell
Developer
LISAsoft

________________________________________
From: postgis-users-bounces at postgis.refractions.net [postgis-users-bounces at postgis.refractions.net] On Behalf Of James Sewell [James.Sewell at lisasoft.com]
Sent: Tuesday, 21 June 2011 1:50 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Problem with ST_intersects

Hello All,

I think I have found a bug. For the data attached the following commands yield interesting results, with the output of ST_intersects seemingly changed by the where clause.

  plm25=> select  a.id, ST_intersects(a.the_geom, b.the_geom) from apoly as a, aright as b where a.id = 1954 or a.id =2034 order by id;
    id  | st_intersects
  ------+---------------
   1954 | f
   2034 | t
  (2 rows)

  plm25=> select  a.id, ST_intersects(a.the_geom, b.the_geom) from apoly as a, aright as b  where a.id = 1954 or a.id =2033 order by id;
    id  | st_intersects
  ------+---------------
   1954 | t
   2033 | t
  (2 rows)

Anyone have any ideas why this might be so?

----
James Sewell
Solutions Architect
Ardec International
Office: (03) 86803200
Mobile: 0414 688 892


The contents of this email are confidential and may be subject to legal or professional privilege and copyright. No representation is made that this email is free of viruses or other defects. If you have received this communication in error, you may not copy or distribute any part of it or otherwise disclose its contents to anyone. Please advise the sender of your incorrect receipt of this correspondence.