From: | Erik Jones <erik(at)myemma(dot)com> |
---|---|
To: | chrisj <chrisj(dot)wood(at)sympatico(dot)ca> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: error with mor than 1 sub-select |
Date: | 2006-08-23 14:57:45 |
Message-ID: | 44EC6CE9.70809@myemma.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)myemma(dot)com>
software development
emma(r)
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2006-08-23 16:11:47 | Re: SQL92 compliance |
Previous Message | chrisj | 2006-08-23 02:26:26 | Re: error with mor than 1 sub-select |