[postgis-users] simple spatial sql question

[Obe, Regina]

Well first it looks like you spelled intersection wrong (you spelled it
intersectsion)

aside from that I don't see anything else syntactically wrong with your
query.


-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Sean
Grimland
Sent: Thursday, August 23, 2007 10:03 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] simple spatial sql question

I am a newbie to sql and am having a problem with this
query.  The explain query tool in pgAdmin says that
there is a syntax error near the SELECT but I can't
figure out what the error is.  Any help is greatly
appreciated. 

CREATE TABLE hydro.bra_hydro as
SELECT intersectsion(r.the_geom, m.the_geom) AS
intersection_geom,
r.*
FROM hydro.watrcrsl AS r, cadastre.countries_2004 AS m
WHERE r.the_geom && m.the_geom
AND intersects(r.the_geom, m.the_geom)
AND m.iso_3digit = 'BRA';


Sean


       
________________________________________________________________________
____________Ready for the edge of your seat? 
Check out tonight's top picks on Yahoo! TV. 
http://tv.yahoo.com/
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.