Re: Function fixing - PostgreSQL 9.2

On Mon, Feb 29, 2016 at 2:56 PM, drum(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)com>
wrote:

> *Question:*
>
> Payments in a Pending state cannot be invoiced and are excluded from the
> Invoice Runs section, but they are showing in the count mechanic.
>
> How can I solve this?
>

​In 9.2 you probably need to convert the count into a conditional sum:

SELECT sum(CASE WHEN <boolean> THEN 1 ELSE 0 END) FROM data;

You can probably do the same with count since it excludes nulls.

SELECT count(NULLIF(invoice_status, 'Pending') FROM invoices;

​9.4 introduced a FILTER clause for Aggregate Expressions that can do this
much more cleanly and efficiently.​

​http://www.postgresql.org/docs/9.4/static/sql-expressions.html​

David J.