| 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 16:53:11 |
| Message-ID: | C5E3EF26-9675-4482-9249-68CF377A33BC@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Thank you Thomas!
Is there a way for the code below to determine the number of rows in the table and use it?
Thanks, Joel
On Apr 30, 2011, at 5:48 PM, Thomas Markus wrote:
> Hi,
>
> try something like this:
>
> select
> trunc(random() * 10.)/10.
> , count(*)
> from
> generate_series(1,2000000)
> group by 1 order by 2
--------------------------------------------------------------------------
- for hire: mac osx device driver ninja, kernel extensions and usb drivers
---------------------+------------+---------------------------------------
http://wagerlabs.com | @wagerlabs | http://www.linkedin.com/in/joelreymont
---------------------+------------+---------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Reymont | 2011-04-30 17:00:34 | Re: histogram |
| Previous Message | Thomas Markus | 2011-04-30 16:48:59 | Re: histogram |