Apparently, in a SELECT query, it is possible to do the following in the selected columns:
SELECT aggregate(col) FILTER(condition) FROM table;
Needs to be investigated, this is an aggregate expression and should be managed by the parser but apparently it is not.
Details here: https://www.postgresql.org/docs/9.4/static/sql-expressions.html
Apparently, in a SELECT query, it is possible to do the following in the selected columns:
Needs to be investigated, this is an aggregate expression and should be managed by the parser but apparently it is not.
Details here: https://www.postgresql.org/docs/9.4/static/sql-expressions.html