SELECT COUNT(xxx.*) FROM () 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 () xxx
It worked for me.
Regards,
Suller Andras
---(end of broadcast)---
TIP 5: Have
Hello everybody,
I’m a newbie to PostgreSQL.
I have the following query:
SELECT
DISTINCT (at.*)
FROM
AGRUPACION_TERRITORIAL
at,
LINK_AGRUP_TE_MUNICIPIO link,
MUNICIPIO m,
PROVINCIA p,
CCAA c
WHERE
at.agru_id_agrupacion_t =
link.agmu_id_agrupacion_t AND
link.agmu