X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DE9DA529F9 for ; Fri, 12 Aug 2005 01:17:23 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26648-05 for ; Fri, 12 Aug 2005 04:17:19 +0000 (GMT) Received: from web33405.mail.mud.yahoo.com (web33405.mail.mud.yahoo.com [68.142.206.137]) by svr1.postgresql.org (Postfix) with SMTP id 64794528E6 for ; Fri, 12 Aug 2005 01:17:18 -0300 (ADT) Received: (qmail 27133 invoked by uid 60001); 12 Aug 2005 04:17:18 -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=3aSUO6XGDX73chxwyHHXrUwITe0wkwqC/K9KrGxquAXNH53MqWiovNXlbZ4IqAROwhhsed3mHnscyHz2aubEtShRnDdf3HdnE0kNelr9vi9cjr8llQzi4HAiwyiU0NQ4s39aYrknS14thwBY3PQgyCyuKbcauQqbnyQvGEESeFQ= ; Message-ID: <20050812041718.27131.qmail@web33405.mail.mud.yahoo.com> Received: from [222.124.69.59] by web33405.mail.mud.yahoo.com via HTTP; Thu, 11 Aug 2005 21:17:18 PDT Date: Thu, 11 Aug 2005 21:17:18 -0700 (PDT) From: Louise Catherine Subject: Re: about subselect To: Tom Lane Cc: pgsql-sql@postgresql.org In-Reply-To: <25508.1123819406@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.625 tagged_above=0 required=5 tests=[AWL=0.840, DNS_FROM_RFC_ABUSE=0.374, FROM_HAS_MIXED_NUMS=0.298, FROM_HAS_MIXED_NUMS3=1.113] X-Spam-Level: ** X-Archive-Number: 200508/65 X-Sequence-Number: 22293 I guess there's no other way,except adding the table name one by one. Thank you very much, Louise Catherine. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com