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