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 > > -- View this message in context: http://www.nabble.com/error-with-more-than-1-sub-select-tf2149934.html#a5937248 Sent from the PostgreSQL - sql forum at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings