Query Praise!

Поиск
Список
Период
Сортировка
Искать
От
Matthew Hagerty
Тема
Query Praise!
Дата
Msg-id
5.1.0.14.2.20020419152136.00b50938@imap.brwholesale.com
Список
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 по дате отправления
От: Jie Liang
Дата:
От: Rajesh Kumar Mallah
Дата:
FAQ