Paul Smith wrote:
It's actually ST_Intersects from PostGIS (some of the PostGIS function names are still recognize without the leading "ST_").
Not for too much longer - these have been deprecated for a while ;)
http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2574404 # select postgis_version(); postgis_version --------------------------------------- 1.3 USE_GEOS=USE_PROJ=1 USE_STATS=1
Can you do a "SELECT postgis_full_version()"? If you're running anything less than 1.3.6, then the first thing you must do is upgrade. 1.3.6 has several important memory-leak fixes IIRC.
HTH, Mark. -- Mark Cave-Ayland - Senior Technical Architect PostgreSQL - PostGIS Sirius Corporation plc - control through freedom http://www.siriusit.co.uk t: +44 870 608 0063 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general