Re: error with mor than 1 sub-select

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)