> Well, you don't need to reference the VIEW (doesn't make sense anyway)
> but your OBJEKT table.
The idea was that
- only special objects (i.e. products) can be in the baskets
- only products that aren't yet expired can be in the baskets.
I agree, that basket should be an objekt, but due to compatibility reasons I'd
rather leave it as a special table.
> Further the Referencing should start from your OBJEKT table, so you
> could cascade through all tables without any problem.
>> -- This is the virtual product table
>> CREATE VIEW product AS SELECT * FROM objekt JOIN price USING
>> (id_objekt) LEFT OUTER JOIN expire USING (id_objekt) WHERE expire IS
>> NULL OR expire > now();
e-Trolley Sayegh & John, Nabil Sayegh
Tel.: 0700 etrolley /// 0700 38765539
Fax.: +49 69 8299381-8
PGP : http://www.e-trolley.de
In response to
pgsql-novice by date
|Next:||From: kynn||Date: 2004-02-08 17:04:54|
|Subject: How to read data from a file?|
|Previous:||From: Nabil Sayegh||Date: 2004-02-08 01:05:13|
|Subject: Re: RI / foreign key on VIEW|