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
When using "pg_dumpall" and a subsequent "psql -e" to rebuild the data base
the process failed. The failure was due to the "pg_dumpall" (and "pg_dump") handling
of CONSTRAINTS. Details are provided below.
Is this a known bug? Is there a patch for it?
tnx,
mike
--
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
Generally, something like
select count(vnr), enr
from votes
group by err
order by 1 desc
should work. But I tried it only with my own tables ... For
referencing to the first column of the resulting table ("order by 1")
you can also use
select count(vnr) as the
