Brian Kalbfus wrote: > > The SQL will return a row if the jobhostagent field matches every time > (the OR clause is on the same level as all the AND clauses). We need to > group the last two clauses:
Thanks Brian, I've applied a patch per your suggestion. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq