Re: Enforcing Join condition

On Nov 15, 2007 5:52 PM, Sam Mason <sam@samason.me.uk> wrote:
> What I tend to do here, is something like:
>
>   CREATE TABLE test (
>     type  INTEGER,
>     ref1 INTEGER REFERENCES table1 CHECK ((type = 1) = (ref1 IS NOT NULL)),
>     ref2 INTEGER REFERENCES table2 CHECK ((type = 2) = (ref2 IS NOT NULL)),
>     ref3 INTEGER REFERENCES table3 CHECK ((type = 3) = (ref3 IS NOT NULL))
>   );

Thanks for sharing. Will try it. But, we have more than 10 types in
one table. Will be tough to handle.

Ma Sivakumar
--
மா சிவகுமார்
எல்லோரும் எல்லாமும் பெற வேண்டும்
http://masivakumar.blogspot.com