X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D25124763B1 for ; Tue, 13 May 2003 15:19:08 -0400 (EDT) Received: from secure.tritus.ca (baxter.tritus.ca [209.47.166.15]) by postgresql.org (Postfix) with ESMTP id 4067C4763AF for ; Tue, 13 May 2003 15:19:08 -0400 (EDT) Received: from [10.200.200.129] (CPE00045ae165bc-CM014320108734.cpe.net.cable.rogers.com [::ffff:24.157.7.10]) (AUTH: CRAM-MD5 adam@tritus.ca, TLS: TLSv1/SSLv3, 168bits, DES-CBC3-SHA) by secure.tritus.ca with esmtp; Tue, 13 May 2003 15:19:07 -0400 Date: Tue, 13 May 2003 15:19:03 -0400 From: Adam Sherman To: josh@agliodbs.com, pgsql-sql@postgresql.org Subject: Re: Locating all Children given Set of Parents Message-ID: <202340000.1052853543@saturn> In-Reply-To: <200305131201.45493.josh@agliodbs.com> References: <184690000.1052842782@saturn> <200305130947.46844.josh@agliodbs.com> <194520000.1052848010@saturn> <200305131201.45493.josh@agliodbs.com> X-Mailer: Mulberry/3.0.3 (Linux/x86) X-OpenPGP: 82C7 7288 650F 8F77 2FFB C170 3698 125A 79C3 FC80 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Spam-Status: No, hits=-32.5 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/236 X-Sequence-Number: 13401 On 05/13/03 12:01:45 -0700 Josh Berkus wrote: > Which column you use isn't important, just don't use "SELECT *" Oh? I just did, and it worked fine. I take it this is a performance issue? Thanks again for all your help, A. -- Adam Sherman Tritus CG Inc. http://www.tritus.ca/ +1 (613) 797-6819