I just found out that postgres (And possibly others?) supports FILTER on
aggregate functions in general, not just when they're used as a window
function.
Trivial example:
SELECT count(*), count(*) FILTER (WHERE amount > 100) FROM blah
which is a lot cleaner than
SELECT count(*), sum(CASE WHEN amount > 100 THEN 1 ELSE 0 END) FROM blah
Would be nice to have someday...
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
