On Wed, Jul 25, 2012 at 01:02:59PM +0100, Rebecca Clarke wrote: > I have resolved the issue. > > It was happening because there was a record with an empty polygon. > > When I added this code into the query it worked successfully. > > CASE WHEN ST_IsEmpty(st_astext(the_geom)) THEN false ELSE > st_isvalid(the_geom) END
So are you saying that ST_IsValid('POLYGON EMPTY'::geometry) and ST_Contains('POLYGON EMPTY'::geometry, 'POLYGON EMPTY'::geometry) both crash for you ? They work fine for me as of PostGIS 1.5.4 --strk; ,------o-. | __/ | Delivering high quality PostGIS 2.1 | / 2.1 | http://strk.keybit.net - http://vizzuality.com `-o------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users