Received: from uni-bremen.de (root@moritz33.zfn.uni-bremen.de [134.102.6.73]) by hub.org (8.8.8/8.8.8) with ESMTP id DAA01749 for ; Mon, 19 Oct 1998 03:41:07 -0400 (EDT) (envelope-from umehlig@uni-bremen.de) Received: (from umehlig@localhost) by uni-bremen.de (8.9.1/8.9.1) id JAA01739; Mon, 19 Oct 1998 09:39:47 +0200 Date: Mon, 19 Oct 1998 09:39:47 +0200 From: Ulf Mehlig Message-Id: <199810190739.JAA01739@uni-bremen.de> To: pgsql-sql@postgreSQL.org Subject: `statistical' aggregate functions etc. I'm a novice to postgresql, so please excuse if I'm addressing to the wrong mailing list! I need to specify some column functions for statistical analysis, e.g. standard deviation or variance. After reading the user's guideI think that's to realize with aggregates, but with those docs only I cannot figure out how to do it -- does anybody know whether there is a ready-for-use "statistics" package, or how to write something that's usable in a SQL statement like this: select date, avg(temperature), stddev(temperature) from temperatures where date between '01.01.1999' and '15.02.1999' group by date ? Other question: I'm used to use DB2/2, and DB2/2 has functions like "month(some_date)" and "hour(some_timestamp)". Are there equivalents in postgresql? Many thanks in advance for help + patience! Ulf -- ====================================================================== %%%%% Ulf Mehlig %%%%!%%% Projekt "MADAM" %%%% %!% %%%% ---------------------------------------------------- ---| %%% MADAM: MAngrove | Center for Tropical Marine ||--%!% Dynamics | Biology || And | Fahrenheitstrasse 1 _ /||\_/\_ Management | / / \ \ ~~~~~~~~~~~~~~~~~ | 28359 Bremen/Germany ~~~~~~~~~~~~~~~~~~~~