Re: Aggregate Function to return most common value for a column

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: artacus(at)comcast(dot)net
Cc: David Fetter <david(at)fetter(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Aggregate Function to return most common value for a column
Date: 2009-05-22 21:40:51
Message-ID: 20090522214051.GN4466@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

artacus(at)comcast(dot)net wrote:

> 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().

Hey, if you want to add your functions to http://wiki.postgresql.org/wiki/Snippets ,
that would be great.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leif B. Kristensen 2009-05-22 22:02:39 Re: Aggregate Function to return most common value for a column
Previous Message David Fetter 2009-05-22 20:36:07 Re: Aggregate Function to return most common value for a column