Re: Calcul de médiane

From: Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr>
To: Sébastien DINOT <sebastien(dot)dinot(at)free(dot)fr>
Cc: pgsql-fr-generale(at)postgresql(dot)org
Subject: Re: Calcul de médiane
Date: 2007-02-21 12:59:30
Message-ID: 20070221125930.GA4482@nic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

On Wed, Feb 21, 2007 at 12:22:58PM +0100,
Stephane Bortzmeyer <bortzmeyer(at)nic(dot)fr> wrote
a message of 65 lines which said:

> SELECT min(valeur) AS median FROM Data
> WHERE occurrences_cumulees(valeur) >= Moitie_population();

Après, je laisse les lecteurs déboguer les cas rigolos comme celui où
aucune occurrence n'est pile sur la médiane, etc.

In response to

Responses

Browse pgsql-fr-generale by date

  From Date Subject
Next Message Emmanuel Seyman 2007-02-21 13:05:32 Re: Calcul de médiane
Previous Message Stephane Bortzmeyer 2007-02-21 11:22:58 Re: Calcul de médiane