[postgis-users] simple spatial sql question

[Sean Grimland]

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/