Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 28 Sep 2005 12:13:43 +0400
- Message-id: <auto-000571638207(at)umail(dot)ru>
>> 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.
- Follow-Ups:
- Re: effective SELECT from child tables
- From: Simon Riggs
- Re: effective SELECT from child tables
- References:
- Re: effective SELECT from child tables
- From: Tom Lane
- Re: effective SELECT from child tables
- Prev by Date: Re: effective SELECT from child tables
- Next by Date: Re: Making pgxs builds work with a relocated installation
- Previous by thread: Re: effective SELECT from child tables
- Next by thread: Re: effective SELECT from child tables
- Indexes: