On Mon, Feb 29, 2016 at 6:14 PM, drum.lu...@gmail.com <drum.lu...@gmail.com> wrote:
> > > On 1 March 2016 at 11:35, David G. Johnston <david.g.johns...@gmail.com> > wrote: > >> 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. >> >> > Thank you David... > > Can you please show me how it would be with the new changes? > > I barely scanned your original query - just read the description. I don't have the inclination - especially without a self-contained example - to make changes to it. David J.
