Re: keeping 3 tables in sync w/ each other

2007/9/19, Ow Mun Heng <Ow.Mun.Heng@wdc.com>:

(...)

> simulate a delete
> => delete from parent where id in (select id from child);
> DELETE 6
>
> => select * from parent;
>  id |  data1
> ----+---------
>   2 | parent2
>   3 | parent3
>   4 | parent4
>
> => select * from child;
>  id | data1
> ----+-------
> (0 rows)
>
Yes. You can however try

SELECT FROM  ... ONLY parent   ...
(that's what I used in example)

and
DELETE FROM  ... ONLY parent ...



--
Filip Rembiałkowski