Skip site navigation (1) Skip section navigation (2)

Re: effective SELECT from child tables

From: "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: effective SELECT from child tables
Date: 2005-09-28 08:13:43
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
>> Let table A be inherited by A1, A2, A3.
>> How to select from A records where actual relations are A1, A2 ?

>Why not just select directly from the child tables?  I can't get excited
>about optimizing the case you propose.

Because "WHERE concrete_class IN (a,b,c)" is much more convenient and
flexible way of forming select then manually split request into many unions.

Also, this query runs on top of "abstract class", so inheritance really
assists me here.

In response to


pgsql-hackers by date

Next:From: Dave PageDate: 2005-09-28 09:05:48
Subject: Re: Making pgxs builds work with a relocated installation
Previous:From: Ilia KantorDate: 2005-09-28 08:12:53
Subject: Re: effective SELECT from child tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group