From: | Ulf Mehlig <umehlig(at)uni-bremen(dot)de> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | aggregate question |
Date: | 1998-10-21 06:22:15 |
Message-ID: | 199810210622.IAA01691@uni-bremen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I posted the questions below a few days ago to the SQL list, but
apparently there is nobody there who can help -- maybe I'm luckier in
this list? :-)
----------------------------------------------------------------------
I'm a novice to postgresql, so please excuse me 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 guide I
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 <ulf(dot)mehlig(at)uni-bremen(dot)de>
%%%%!%%% Projekt "MADAM" <umehlig(at)uni-bremen(dot)de>
%%%% %!% %%%% ----------------------------------------------------
---| %%% MADAM: MAngrove | Center for Tropical Marine
||--%!% Dynamics | Biology
|| And | Fahrenheitstrasse 1
_ /||\_/\_ Management |
/ / \ \ ~~~~~~~~~~~~~~~~~ | 28359 Bremen/Germany
~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Carilda A. Thomas | 1998-10-21 06:44:53 | re: Help...(summerd@cs.unm.edu) |
Previous Message | Summer | 1998-10-21 02:21:08 | Help... |