Re: [GENERAL] average/stddev on all values returned by a select distinct

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

[GENERAL] average/stddev on all values returned by a select distinct

lengths returned by this query. Something like... select average(select distinct on (id) length(consensus) from cluster order by id,length(consensus) desc); Could someone tell me how it's done? Thanks -- Ann "In a world without walls and fences - who needs Windows

Re: [GENERAL] memory leak of PQmakeEmptyPGresult?

hi,Gaetano Mendola:      you wrote:   >  Ann wrote:>  I found the reason of this question and fixed the bug :))> > Why then don't you share it ?      em ,because i make a stupid mistake in programming!! :((     I made use of transactions to ensure database consistency, and then

Re: [GENERAL] memory leak of PQmakeEmptyPGresult??

I found the reason of this question and fixed the bug :))xiaoling he <[EMAIL PROTECTED]> wrote: I try to detect potential memory management bugs of my program with valgrind. (PostgreSQL is at version 8.0 beta2. Operating System is Red Hat Enterprise Linux 3. Valgrind is at version 2.2.0.)   　　Afte

[GENERAL] serverless postgres, embedded firebird, etc.

n't seem to corrupt data except in the cases described above. The next version of Firebird also forces Windows to flush its cache regularly, which should be a boon for our Latin American users. Best regards, Ann ---(end of broadcast)--- TIP