ST_Overlaps has a very particular meaning (partly in, partly out). Do
you mean ST_Intersects (which is equivalent to NOT ST_Disjoint()) ?
P
On 17-Oct-07, at 7:01 AM, Jørn Vegard Røsnes wrote:
Hi,
I have just upgraded my database with the following
PostgreSQL 8.1.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
3.3.4 (pre
3.3.5 20040809)
Postgis 1.3.1 - 2007-10-17 12:46:11
GEOS: 3.0.0rc4-CAPI-1.3.3
PROJ: Rel. 4.5.0, 22 Oct 2006
The problem is that ST_overlap doesn't seems to work
select st_overlaps (GeomFromText('POLYGON((-27.7124 86.6147,39.5851
86.6147,39.5851 26.4173,-27.7124 26.4173,-27.7124 86.6147))',4326),
geom)
from dataset;
st_overlaps
-------------
f
f
(2 rows)
select astext(geom) from dataset;
astext
----------------------------------------------------------------------
-------------------------
POLYGON((18.1855 58.0681,11.2994 57.2716,12.9173 53.8532,19.2302
54.6196,18.1855 58.0681))
POLYGON((-3.81808 50.6748,-9.6857 51.425,-10.5383 48.1472,-5.04416
47.4111,-3.81808 50.6748))
(2 rows)
From \d dataset:
Check constraints:
"enforce_dims_geom" CHECK (ndims(geom) = 2)
"enforce_geotype_geom" CHECK (geometrytype(geom) =
'POLYGON'::text OR geom
IS NULL)
"enforce_srid_geom" CHECK (srid(geom) = 4326)
As far as I can see, the first query should have returned true for
both
datasets.
Can someone see the problem?
kind regards
Jørn Vegard
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
