[GENERAL] Percent of Total in Histogram Query

2012-11-15 Thread Paul Jungwirth
Hello, I'd like to write a histogram-like query that shows these columns: - x-value from 0 to k. - number of rows with that x-value. - number of rows seen so far (i.e. with the current x-value or less). - % of total rows seen so far. The following query works for the first three columns,

Re: [GENERAL] Percent of Total in Histogram Query

2012-11-15 Thread David Johnston
From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Paul Jungwirth Sent: Thursday, November 15, 2012 5:44 PM To: pgsql-general@postgresql.org Subject: [GENERAL] Percent of Total in Histogram Query Hello, I'd like to write a histogram-like