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