Re: howto delete using a join ? - Mailing list pgsql-sql

From Dmitriy Igrishin
Subject Re: howto delete using a join ?
Date
Msg-id AANLkTik0=PnMF15WGQAFJbqPF5Qa42tADoYxzdH9w_OG@mail.gmail.com
Whole thread Raw
In response to howto delete using a join ?  (Andreas <maps.on@gmx.net>)
List pgsql-sql
Hey Andreas,<br /><br />You may want to use the USING clause:<br /><br />DELETE FROM events USING event_types<br /> 
WHEREevents.event_type_fk = <a href="http://event_types.event_type.id/"
target="_blank">event_types.event_type.id</a><br/>   AND relevance_level IN ( 1, 3, 5, 7)<br />   AND
<ANY_ANOTHER_CONDITION_YOU_<divclass="ii gt" id=":1s8">NEED> ;<br /><br />Regards,<br />Dmitriy<br /></div><br /> 

pgsql-sql by date:

Previous
From: Andreas
Date:
Subject: howto delete using a join ?
Next
From: Joshua Tolley
Date:
Subject: Re: howto delete using a join ?