On Mon, Feb 29, 2016 at 2:56 PM, drum.lu...@gmail.com <drum.lu...@gmail.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.
