Re: keeping 3 tables in sync w/ each other

On Wed, 2007-09-19 at 11:05 +0100, Filip Rembiałkowski wrote:
> 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 ...

Here's the obigatory Ooohhh or the simpson's "Doh!"

Let me re-try this and see how it goes.

Many thanks for the Ooo... ( I feel like the "green aliens" in Toy
Story)