On 1 March 2016 at 11:35, David G. Johnston <david.g.johnston@gmail.com> wrote:On Mon, Feb 29, 2016 at 2:56 PM, drum.lucas@gmail.com <drum.lucas@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.htmlDavid J.Thank you David...Can you please show me how it would be with the new changes?
On Mon, Feb 29, 2016 at 2:56 PM, drum.lucas@gmail.com <drum.lucas@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.htmlDavid J.
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?
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?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
