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 <[EMAIL PROTECTED]>
software development
emma(r)
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
