Re: MEDIAN as custom aggregate?

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Josh Berkus" <josh(at)agliodbs(dot)com>
Cc: Allan Engelhardt <allane(at)cybaea(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: MEDIAN as custom aggregate?
Date: 2001-10-15 22:44:06
Message-ID: web-148453@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom,

> Um ... does that work? I thought LIMIT was fairly restrictive about
> what it would take as a parameter --- like, constants or $n
> parameters
> only.
>
> I do not know of any median-finding algorithm that doesn't require a
> depressingly large amount of storage...

Me neither. You're right; the query didn't work.

Here's a link to the median-finding function I posted to the CookBook:

http://www.brasileiro.net/postgres/cookbook/view-one-recipe.adp?recipe_id=1654

Anyone who can improve it is welcome!

-Josh

______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-10-16 00:12:30 Re: Cenceptual help needed - periodic events
Previous Message Michael Richards 2001-10-15 22:29:51 When will vacuum go away?