<snip> > select coalesce(col,'Null'), > (count(coalesce(col,'Null'))::numeric/(select count(*) from > some_table))*100 from some_table group by col; > coalesce | ?column? > ----------+------------------------- > Null | 13.33333333333333333300 > N | 20.00000000000000000000 > A | 26.66666666666666666700 > L | 40.00000000000000000000 > > Note that it works, but we get long ugly numbers, and the column has > no name (?column?). Let's fix that:
What does ::numeric signify? I'm using the jdbc driver from http://jdbc.postgresql.org/ in SQuirreL and it asks me for the value of :numeric. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general