histogram

From: Joel Reymont <joelr1(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: histogram
Date: 2011-04-30 16:37:17
Message-ID: 8184ACF3-2D44-474A-A6D3-739C846AF26F@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a column of 2 million float values from 0 to 1.

I would like to figure out how many values fit into buckets spaced by 0.10, e.g. from 0 to 0.10, from 0.10 to 0.20, etc.

What is the best way to do this?

Thanks, Joel

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Markus 2011-04-30 16:48:59 Re: histogram
Previous Message Martijn van Oosterhout 2011-04-30 14:40:25 Re: Short-circuit boolean evaluation