Re: [GENERAL] aggregate question

1998-10-22 Thread William D. McCoy
Ulf, As a partial answer to your question about statistical functions and std. deviation in particular, I have pulled out an example query that I have used in the past as an example: select lab_no, prep_no, avg(hai), max(hai), min(hai), |/((sum(hai^2)-(count(hai)::float8)*(avg(hai)^2))/count(h

Re: [GENERAL] aggregate question

1998-10-22 Thread Ulf Mehlig
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

Re: [GENERAL] aggregate question

1998-10-21 Thread Sferacarta Software
Hello Ulf, mercoledì, 21 ottobre 98, you wrote: UM> I posted the questions below a few days ago to the SQL list, but UM> apparently there is nobody there who can help -- maybe I'm luckier in UM> this list? :-) UM> -- UM> I'm a