Request a Demo
Home   >   mailing lists

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
In response to howto delete using a join ?  (Andreas <maps.on@gmx.net>)
List pgsql-sql
Tree view
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

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 ?