Re: error with mor than 1 sub-select

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