Re: Function fixing - PostgreSQL 9.2
| От | David G. Johnston |
|---|---|
| Тема | Re: Function fixing - PostgreSQL 9.2 |
| Дата | |
| Msg-id | CAKFQuwb1bRVERP5zQVdV3Sc8rXs5HvjArQiCWqSqiGLeBb+4NA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Function fixing - PostgreSQL 9.2 ("drum.lucas@gmail.com" <drum.lucas@gmail.com>) |
| Ответы |
Re: Function fixing - PostgreSQL 9.2
|
| Список | pgsql-general |
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.
David J.
В списке pgsql-general по дате отправления: