SELECT COUNT(xxx.*) FROM (<the query above>) xxx
This cause an error for me: ERROR: cannot pass result of subquery or join "xxx" to a function
Try this instead: SELECT COUNT(*) FROM (<the query above>) xxx It worked for me. Regards, Suller Andras
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html