Delete across 5 Joined tables - Mailing list pgsql-general

From Fuzzygoth
Subject Delete across 5 Joined tables
Date
Msg-id 2bc56296-2b46-49e1-bc46-f51f92813276@d1g2000hsg.googlegroups.com
Whole thread Raw
Responses Re: Delete across 5 Joined tables
List pgsql-general
Hi,
I am trying to delete a set of related record across the whole
database, In tests I
have managed to delete records from 2 tables using the code below.

DELETE FROM phillipsd.tablea using phillipsd.tableb WHERE tablea.one =
2;

but I need to be able to delete from up to 5 different tables, is
there a quick and
simple way of doing this? can someone post an example?

Cheers
David P

pgsql-general by date:

Previous
From: Nick
Date:
Subject: Re: Incorrect results with NOT IN
Next
From: Thomas Kellerer
Date:
Subject: Re: Windows Installation Problem