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 :
> 
> (...)
> 
> > 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)