Postgres Pro
Downloads
Home   >   mailing lists

Re: COUNT on a DISTINCT query - Mailing list pgsql-sql

From Suller András
Subject Re: COUNT on a DISTINCT query
Date
Msg-id 409B9AEC.1080302@freemail.hu
Whole thread Raw
In response to COUNT on a DISTINCT query  ("Freddy Villalba Arias" <fvillalba@madrid.bilbomatica.es>)
List pgsql-sql
Tree view 
>  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

pgsql-sql by date:

Previous
From: "Kornelije"
Date:
Subject: SELECT - ORDER BY Croatian characters ....
Next
From: Jean-Luc Lachance
Date:
Subject: Re: SUM() & GROUP BY