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