[postgis-users] Intersection ion 0.7.4 ???

[Alexander Pucher]

Hi,

I just had a look at the OGC example in the 0.7.4 source tree. In file 
'2-queries.sql', various tests for new GIS functions are mentioned, 
among them INTERSECTION.
I set up a new database, filled it with data and tried the following:

SELECT Intersection(nuec_l0.the_geom, road.the_geom) FROM nuec_l0,road;


but got the following error:

Error - /usr/local/httpd/htdocs/php/phpPgAdmin/sql.php -- Line: 112
PostgreSQL said: ERROR: Function 'intersection(geometry, geometry)' does not
exist Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
Your query:
SELECT Intersection(nuec_l0.the_geom, road.the_geom)
FROM nuec_l0,road



So my question is:
Is this my fault (i.e. wrong query syntax) or is this function (as well 
as the others mentioned in the test file) not yet included in PostGIS?

Best regards,
alex

-- 
________________________________________________________

Institut fuer Geographie und Regionalforschung
Universitaet Wien
Kartografie und Geoinformation

Departement of Geography and Regional Research
University of Vienna
Cartography and GIS

Universitaetstr. 7, A-1010 Wien, AUSTRIA

Tel: (+43 1) 4277 48644
Fax: (+43 1) 4277 48649
E-mail: alexander.pucher at univie.ac.at

FTP: ftp://ftp.gis.univie.ac.at
WWW: http://www.gis.univie.ac.at/karto
--------------------------------------------------------
Virtual Map Forum: http://www.gis.univie.ac.at/vmf
--------------------------------------------------------
It's not that I'm afraid to die, 
I just don't want to be there when it happens -- Woody Allen