Re: howto delete using a join ?

From: Dmitriy Igrishin <dmitigr(at)gmail(dot)com>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: howto delete using a join ?
Date: 2010-07-24 09:22:32
Message-ID: AANLkTik0=PnMF15WGQAFJbqPF5Qa42tADoYxzdH9w_OG@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hey Andreas,

You may want to use the USING clause:

DELETE FROM events USING event_types
WHERE events.event_type_fk = event_types.event_type.id
AND relevance_level IN ( 1, 3, 5, 7)
AND <ANY_ANOTHER_CONDITION_YOU_
NEED> ;

Regards,
Dmitriy

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Joshua Tolley 2010-07-24 11:47:24 Re: howto delete using a join ?
Previous Message Andreas 2010-07-24 04:05:57 howto delete using a join ?