X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id A86C59FA278 for ; Wed, 24 May 2006 14:49:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 10991-10 for ; Wed, 24 May 2006 14:48:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31807.mail.mud.yahoo.com (web31807.mail.mud.yahoo.com [68.142.207.70]) by postgresql.org (Postfix) with SMTP id C3C4C9F94EA for ; Wed, 24 May 2006 14:48:56 -0300 (ADT) Received: (qmail 47652 invoked by uid 60001); 24 May 2006 17:48:55 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=zgNcw9xUONu2F0Szt1jz/EHZNk3CdF3YVAJDGXecFIVPof+Qt91P44azO/HWB2MijYrnRkMe/zKNARkmifgfn4pQ0Wreu9x3XTYA5wFAv2+qnShSK7yJVdHZIgpU4JlrN3tr1dTjgXKk1a4iNB09s4YcwcGid6rKvE6qySgmPQ0= ; Message-ID: <20060524174855.47650.qmail@web31807.mail.mud.yahoo.com> Received: from [63.203.180.122] by web31807.mail.mud.yahoo.com via HTTP; Wed, 24 May 2006 10:48:55 PDT Date: Wed, 24 May 2006 10:48:55 -0700 (PDT) From: Richard Broersma Jr Subject: Re: [SQL] (Ab)Using schemas and inheritance To: Jorge Godoy , Alban Hertroys Cc: "Jim C. Nasby" , pgsql-general@postgresql.org In-Reply-To: <200605241410.46202.jgodoy@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/1184 X-Sequence-Number: 95976 > If I SELECT from the schema it will only retrieve data from the schema. If I > select from the parent table then I'll have all data available -- and for the > parent table I might need some date index.