Re: [GENERAL] aggregate question - Mailing list pgsql-general

From Ulf Mehlig
Subject Re: [GENERAL] aggregate question
Date
Msg-id 199810220928.LAA02334@uni-bremen.de
Whole thread Raw
In response to Re: [GENERAL] aggregate question  (Sferacarta Software <sferac@bo.nettuno.it>)
Responses Re: [GENERAL] aggregate question
List pgsql-general
Hello out there,

many thanks for everybody helping with extracting month information
and so on from date columns.

Realizing that apparently a package with simple statistical
functions/aggregates like standard deviation doesn't exist, I have to
write one on my own. But, as stated earlier, I have problems
understanding the docs (i.e., the manual section "Extending SQL:
Aggregates"). This chapter is a little bit laconic (and others are,
too), and at least for the newcomers it is sometimes difficult to
guess the overall definition principle out of the three examples using
three unexplained for two explained keywords or functions.

I have the suspection that I will spend some hours in front of the
screen before I get a useful do-it-yourself-solution -- if anybody
knows something about more fool-proof documentation texts, or could
send me her or his own aggregate-defining-statements, I would be very
happy ;-)

Thanks in advance,
Ulf

--
======================================================================
 %%%%%            Ulf Mehlig              <ulf.mehlig@uni-bremen.de>
   %%%%!%%%       Projekt "MADAM"         <umehlig@uni-bremen.de>
%%%% %!% %%%%     ----------------------------------------------------
 ---| %%%         MADAM:  MAngrove    |  Center for Tropical Marine
    ||--%!%              Dynamics     |  Biology
    ||                  And           |  Fahrenheitstrasse 1
 _ /||\_/\_            Management     |
/  /    \  \ ~~~~~~~~~~~~~~~~~        |  28359 Bremen/Germany
  ~~~~~~~~~~~~~~~~~~~~

pgsql-general by date:

Previous
From: Ulf Mehlig
Date:
Subject: Re: [GENERAL] Problem with getting the right order
Next
From: Jean-David Beyer
Date:
Subject: I cannot create views in postgreSQL 6.3.2