X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 692439FB300 for ; Tue, 22 Aug 2006 23:26:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 36965-08 for ; Wed, 23 Aug 2006 02:26:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from talk.nabble.com (www.nabble.com [72.21.53.35]) by postgresql.org (Postfix) with ESMTP id E79769FB2B6 for ; Tue, 22 Aug 2006 23:26:27 -0300 (ADT) Received: from [72.21.53.38] (helo=jubjub.nabble.com) by talk.nabble.com with esmtp (Exim 4.50) id 1GFiRm-0005K7-Pu for pgsql-sql@postgresql.org; Tue, 22 Aug 2006 19:26:26 -0700 Message-ID: <5937248.post@talk.nabble.com> Date: Tue, 22 Aug 2006 19:26:26 -0700 (PDT) From: chrisj To: pgsql-sql@postgresql.org Subject: Re: error with mor than 1 sub-select In-Reply-To: <20060823020643.GA60275@winnie.fuhr.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit References: <5936948.post@talk.nabble.com> <20060823020643.GA60275@winnie.fuhr.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.816 tagged_above=0 required=5 tests=SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: *** X-Archive-Number: 200608/162 X-Sequence-Number: 26120 thanks, stupid user error. i guess the pointer on the error message led me astray Michael Fuhr wrote: > > On Tue, Aug 22, 2006 at 06:47:51PM -0700, chrisj wrote: >> The first query works fine, but when a second sub-query is added I get a >> syntax error... >> >> psql protocal2 -U p2user << EOF1 >> select * >> from serv_res SR >> where serv_key = 10 >> and not exists >> (select 1 >> from reservation R >> ) >> -- and not exits > > Does the real query have "exits" instead of "exists"? I created > some test tables and fixed that typo and then both queries worked. > > -- > Michael Fuhr > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > > -- View this message in context: http://www.nabble.com/error-with-more-than-1-sub-select-tf2149934.html#a5937248 Sent from the PostgreSQL - sql forum at Nabble.com.