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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: effective SELECT from child tables

  • From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
  • To: "Ilia Kantor" <ilia(at)obnovlenie(dot)ru>
  • Cc: pgsql-hackers(at)postgresql(dot)org
  • Subject: Re: effective SELECT from child tables
  • Date: Tue, 27 Sep 2005 14:38:12 -0400
  • Message-id: <9475(dot)1127846292(at)sss(dot)pgh(dot)pa(dot)us>
"Ilia Kantor" <ilia(at)obnovlenie(dot)ru> writes:
> 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.

			regards, tom lane
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group