Re: histogram

From: Joel Reymont <joelr1(at)gmail(dot)com>
To: Thomas Markus <t(dot)markus(at)proventis(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: histogram
Date: 2011-04-30 17:03:34
Message-ID: 8E450671-E63B-4CFB-B337-4675302DF8C5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I think this should do what I want

select trunc(distance * 10.)/10., count(*)
from doc_ads
group by 1 order by 1

Thanks, Joel

--------------------------------------------------------------------------
- for hire: mac osx device driver ninja, kernel extensions and usb drivers
---------------------+------------+---------------------------------------
http://wagerlabs.com | @wagerlabs | http://www.linkedin.com/in/joelreymont
---------------------+------------+---------------------------------------

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-04-30 17:29:36 Re: Short-circuit boolean evaluation
Previous Message Joel Reymont 2011-04-30 17:00:34 Re: histogram