Re: Storing "deleted" data

<zeldorblat_at_gmail.com> wrote in message news:1130769897.026173.216650_at_g49g2000cwa.googlegroups.com...
> >b)You can try to declare a foreign key reference to one table AND
another.
>
> That doesn't help, though. Consider the following:
>
> create table livePeople (
> personID int not null,
> ...
> )
>
> create table deadPeople (
> personID int not null,
> ...
> )
>
> create table personComment (
> personID int not null,
> commentID int not null
> )

When looking at the livePeople/deadPeople dichotomy, a thought came to me :

create table People (

    personID int not null,
    ...
 )

create materialized view livePeople ... Received on Tue Nov 01 2005 - 08:50:25 CET