On Fri, May 22, 2009 at 05:23:47PM +0000, artacus@xxxxxxxxxxx wrote: > > On Fri, May 22, 2009 at 03:23:07PM +0000, artacus@xxxxxxxxxxx wrote: > > > I want to use an aggregate function that will return the most > > > commonly occurring value in a column. > > > > It's actually dead simple in Postgres. No C either. You just need to > > create an aggregate function. I wrote a most() aggregate a while > > back that does exactly what you are asking for. Here, I'll add it to > > my blog... > > > > http://scottrbailey.wordpress.com/2009/05/22/postgres-adding-custom-aggregates-most/ > > > Such an aggregate should probably be called, "mode," that being the > > probability/statistics name for the concept. > > Excellent observation Dave. Sometimes I can't see outside of the box I'm in. And at the time I was focusing on text so statistics was in another box. I've update post with final functions for mode(), median() and range(). Thanks! :) Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
