Query Praise! - Mailing list pgsql-sql

From Matthew Hagerty
Subject Query Praise!
Date
Msg-id 5.1.0.14.2.20020419152136.00b50938@imap.brwholesale.com
Whole thread Raw
List pgsql-sql
Haha, Tom Lane (and all the pg developers), you ROCK!  Thanks a million!!!

These kinds of queries save my ass!

select sum(score) from (select distinct on (question_id) score from answers 
where score is not null order by question_id,score) as score;

Matthew



pgsql-sql by date:

Previous
From: Jie Liang
Date:
Subject: Re: How to log outputs from pl/pgsql into a file ?
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: count different values in column?