references and inheritance

From: Masse Jacques <jacques(dot)masse(at)bordeaux(dot)cemagref(dot)fr>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: references and inheritance
Date: 2002-02-26 16:22:45
Message-ID: 0B87317EA62BD211A02A00A0C9DFB7EC9B5E97@hermes.bordeaux.cemagref.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello

As new to postgresql :

for referencing from a table (experiment, fk site_id) to a supertable (site
pk site_id)
inherited by some site_type1, site_type2, ...

is it better to reference each of them or to use the method given by Jon
Obuchowski in the interactive doc for PostgreSQL (Chapter 8 - Inheritance) ?

Thanks
___________________________________________
Jacques Massé
Tel. 33 (0)5 57 89 08 11 - Fax 33 (0)5 57 89 08 01

Browse pgsql-novice by date

  From Date Subject
Next Message Phil Mitchell 2002-02-26 18:32:35 Help formulating multi-table SELECT statement
Previous Message cristi 2002-02-26 06:43:14 update