@djcp Hey if I wanted to index the result of SUM(col1), SUM(col2) on PG how would I do that? I know you've mentioned this is possible.
-
@sgrif I don't think you can do that on an aggregate expression, which act on a set. Index is row level. http://www.postgresql.org/docs/9.1/static/indexes-expressional.html …
-
-
@sgrif Sure! You can get close with a materialized view: https://gist.github.com/djcp/0099e701515ae410ca07 … http://www.postgresql.org/docs/9.3/static/sql-creatematerializedview.html …Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.