Re: Counts and percentages and such

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