Scot Kreienkamp <SKreien@xxxxxxxxxxxx> writes: > There's something wrong with the query that I've written based on what you gave me. It looks like you forgot the ON condition for the next-to-last JOIN, so the parser is still expecting another ON when it runs into the WHERE. Personally I think this sort of FROM construction is pretty bad style anyway, because it takes an eagle eye to see which ON goes with which JOIN, and even worse it's very easy to get them connected up wrongly. You'd be a lot better off with explicit parentheses, viz from (pg_catalog.pg_locks bl join pg_catalog.pg_stat_activity a on bl.pid = a.procpid) join (pg_catalog.pg_locks kl join pg_catalog.pg_stat_activity ka on kl.pid = ka.procpid) on the-long-on-condition-goes-here regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
