Re: Function fixing - PostgreSQL 9.2

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

>
>
> On 1 March 2016 at 11:35, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
> wrote:
>
>> 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.
>>
>>
> 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.
​