> 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?