On 4 Feb 2010, at 20:34, Tim Landscheidt wrote:
> Alban Hertroys wrote:
>
>> [...]
>> Now the intent here is to restrict foreign keys referencing the base class
>> to unitclass records that describe a baseclass and to restrict foreign keys
>> referencing a derived class to unitclass records th
Alban Hertroys wrote:
> [...]
> Now the intent here is to restrict foreign keys referencing the base class to
> unitclass records that describe a baseclass and to restrict foreign keys
> referencing a derived class to unitclass records that do NOT describe a
> baseclass.
> Basically I'm trying
Alban Hertroys writes:
> FOREIGN KEY (base, true) REFERENCES unitclass (name, is_baseclass),
> FOREIGN KEY (derived, false) REFERENCES unitclass(name, is_baseclass)
> I can of course add a few triggers to force that constraint, but I think it
> would be nice if the above syntax could be
