Re: Boolean product of rows in multiple tables

From: Artur Rataj <arataj(at)iitis(dot)gliwice(dot)pl>
To: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Boolean product of rows in multiple tables
Date: 2002-12-31 10:36:09
Message-ID: Pine.LNX.4.33.0212311103160.23734-100000@linux.iitis.gliwice.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 30 Dec 2002, Jean-Luc Lachance wrote:

> Still, if most tables are alike (at least they have id and string) you
> should think about
> inheritance. Create the base table/class with id and string and have all
> the other tables inherit from it.
>

I have tested it -- the indices were used and the queries were fast even
when searching the base tables.

Best regards,
Artur

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Roberto Carrer 2002-12-31 13:22:18 psql:relocation error:psql:unfefined symbol: PQgetssl
Previous Message evon600c 2002-12-31 10:10:37 French date