Re: [GENERAL] aggregate question

Поиск
Список
Период
Сортировка
От Ulf Mehlig
Тема Re: [GENERAL] aggregate question
Дата
Msg-id 199810220928.LAA02334@uni-bremen.de
обсуждение исходный текст
Ответ на Re: [GENERAL] aggregate question  (Sferacarta Software <sferac@bo.nettuno.it>)
Ответы Re: [GENERAL] aggregate question  ("William D. McCoy" <wdmccoy@geo.umass.edu>)
Список 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 по дате отправления:

Предыдущее
От: Ulf Mehlig
Дата:
Сообщение: Re: [GENERAL] Problem with getting the right order
Следующее
От: Jean-David Beyer
Дата:
Сообщение: I cannot create views in postgreSQL 6.3.2