POSTGIS Query

[Milo van der Linden]

delete from table_a where id in (select a.id b. from table_a as a, 
table_b as b where within (a.the_geom, b.the_geom)=true and b.nom='test')

Sven Schroeter schreef:
> Hallo,
> in a mapserver-project I want to start a query for 2 postggis-layers:
>
> select a.id, b.nom from table_a as a, table_b as b where within 
> (a.the_geom, b.the_geom)=true and nom='test';
>
> now I want to delete all datasets from table_a I get as result. How 
> can I set a delete statement in one sql-query with this selection?
>
> Thank you
> Sven


-- 


	

Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
mlinden at zeelandnet.nl <mailto:mlinden at zeelandnet.nl>
milovanderlinden at gmail.com <mailto:milovanderlinden at gmail.com>
milo at 3dsite.nl <mailto:milo at 3dsite.nl>
http://www.3dsite.nl

	  	

De informatie in dit bericht reflecteert mijn persoonlijke mening en 
niet die van een bedrijf of instantie. Aan de informatie kunnen geen 
rechten worden ontleend. Indien dit bericht onderdeel is van een forum, 
mailing-list of community dan gelden automatisch de bij het betreffende 
medium behorende voorwaarden. The information in this message reflects 
my personal opinion and not that of a company or public body. All rights 
reserved.If this message is contained in a mailing-list or community, 
the rights on the medium are automatically adapted.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20071204/7d318f1c/attachment.htm>