histogram - Mailing list pgsql-general

From Joel Reymont
Subject histogram
Date
Msg-id 8184ACF3-2D44-474A-A6D3-739C846AF26F@gmail.com
Whole thread Raw
Responses Re: histogram
List 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
---------------------+------------+---------------------------------------




pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Short-circuit boolean evaluation
Next
From: Thomas Markus
Date:
Subject: Re: histogram