Re: [SQL] Integrity and Inheritance

On 10 Jun 2001, Christophe Labouisse wrote: > I wanted to build the following schema : > > - one "generic" document table with a column doc_id ; > - a couple of "specific" document tables inheriting from doc ; > - a table refering a document by it's id with and integrity constraint > on it. > >

[SQL] Integrity and Inheritance

I wanted to build the following schema : - one "generic" document table with a column doc_id ; - a couple of "specific" document tables inheriting from doc ; - a table refering a document by it's id with and integrity constraint on it. In SQL : CREATE TABLE doc ( doc_id serial PRIMARY K

[SQL] Inconsistent usage of Index

Hi All, I have attached file explaining inconsistent usage of Index. Thanks, Subra __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/