Re: [GENERAL] Calcuate percentage.

[Kaare Rasmussen]

> P.S.  In oracle, I'd use a sub-query:
> 
> SELECT var, COUNT(*) / total_count 
>   FROM temp, 
>        ( SELECT COUNT(*) AS total_count 
>            FROM temp
>        )
> GROUP BY var;

I thought that subqueries were allowed in PostgreSQL after 6.2?