From: Erik Jones <erik@myemma.com>
To: chrisj <chrisj.wood@sympatico.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: error with mor than 1 sub-select
Date: Wed, 23 Aug 2006 09:57:45 -0500
Message-ID: <44EC6CE9.70809@myemma.com> (raw)
In-Reply-To: <5937248.post@talk.nabble.com>
References: <5936948.post@talk.nabble.com>
<20060823020643.GA60275@winnie.fuhr.org>
<5937248.post@talk.nabble.com>
Actually, it pointed you right to it. Notice that exits is just before
where the pointer was.
chrisj wrote:
> 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
>>
>>
>>
>
>
--
erik jones <erik@myemma.com>
software development
emma(r)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: erik@myemma.com, chrisj.wood@sympatico.ca
Subject: Re: error with mor than 1 sub-select
In-Reply-To: <44EC6CE9.70809@myemma.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox