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@myemma.com>
software development
emma(r)