On Tue, Dec 8, 2009 at 2:21 PM, jackassplus <jackassp...@gmail.com> wrote: > <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.
::numeric is a cast in pgsql. The long version looks like: cast (col as numeric) which might work better. I'm no expert on the jdbc driver so your question may require someone else to give a definitive answer. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
