Michael Fuhr wrote:
On Tue, Jul 17, 2007 at 01:51:21PM +0100, ann hedley wrote:
What I want is the average and stddev of the set of lengths returned by
this query. Something like...
select average(select distinct on (id) length(consensus) from cluster
order by id,length(consensus) desc);
On Tue, Jul 17, 2007 at 01:51:21PM +0100, ann hedley wrote:
> What I want is the average and stddev of the set of lengths returned by
> this query. Something like...
>
> select average(select distinct on (id) length(consensus) from cluster
> order by id,length(consensus) desc);
I think this is
I have this query which returns the length of the longest consensus for
each id.
lumbribase=# select distinct on (id) length(consensus) from cluster
order by id,length(consensus) desc;
length
647
680
273
384
1285
What I want is the average and stddev of the set of leng
