From: | Ulf Mehlig <umehlig(at)uni-bremen(dot)de> |
---|---|
To: | pgsql-sql(at)postgreSQL(dot)org |
Subject: | `statistical' aggregate functions etc. |
Date: | 1998-10-19 07:39:47 |
Message-ID: | 199810190739.JAA01739@uni-bremen.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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 <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 | Tony.Curtis | 1998-10-19 13:02:32 | [SQL, regex, words] how to match word boundaries using regex's? |
Previous Message | Taral | 1998-10-18 21:03:59 | RE: [SQL] NULL DATE |