Re:Re: histogram_numeric find the most frequent value

2013-10-16 Thread Richard
good idea, I will try. thanks At 2013-10-16 19:12:30,"Ed Soniat" wrote: You could use a modular math to transform the data in to single value representations of each range you intend to represent with your boundary using a sub select. On Wed, Oct 16, 2013 at 7:09 AM, Richard wrote: I wa

Re: histogram_numeric find the most frequent value

2013-10-16 Thread Ed Soniat
You could use a modular math to transform the data in to single value representations of each range you intend to represent with your boundary using a sub select. On Wed, Oct 16, 2013 at 7:09 AM, Richard wrote: > I want to find the most frequent value of a column, I noticed > histogram_numerc,

histogram_numeric find the most frequent value

2013-10-16 Thread Richard
I want to find the most frequent value of a column, I noticed histogram_numerc, but I cannot specify the bin boundary. The result is not what I want. take an example as follows, I want something like select gid, most_frequent(category) from mytable group by gid. where category is a column w