Postgres Pro
Downloads
Home   >   mailing lists

Re: histogram - Mailing list pgsql-general

From Joel Reymont
Subject Re: histogram
Date
Msg-id 8E450671-E63B-4CFB-B337-4675302DF8C5@gmail.com
Whole thread Raw
In response to Re: histogram  (Thomas Markus <t.markus@proventis.net>)
Responses Re: histogram
List pgsql-general
Tree view 
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
---------------------+------------+---------------------------------------

pgsql-general by date:

Previous
From: Joel Reymont
Date:
Subject: Re: histogram
Next
From: Tom Lane
Date:
Subject: Re: Short-circuit boolean evaluation