Re: Table inheritance - Mailing list pgsql-novice

From Zdravko Balorda
Subject Re: Table inheritance
Date
Msg-id hoi228$2tl5$1@news.hub.org
Whole thread Raw
In response to Re: Table inheritance  (Alan Hodgson <ahodgson@simkin.ca>)
Responses Re: Table inheritance  ("Daniel Staal" <DStaal@usa.net>)
List pgsql-novice
>> A great idea, this inheritance.
>
> It ... doesn't. In fact, it makes them harder, as you need to create them
> and associated indexes on each child table.

Hmm ... But:

SELECT parent_field FROM child_table WHERE child_field = 'something';
does the job. For this one needs foreign key, but if child_table inherits
from parent_table it works without it.

Am I wrong?

Zdravko


pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: FW: plpgsql function help
Next
From: "L. Loewe"
Date:
Subject: slow plan on join when adding where clause