Friday, August 15, 2008

[GENERAL] Delete across 5 Joined tables

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: