Re: Inconsistent results postgresql
| От | Emir Ibrahimbegovic |
|---|---|
| Тема | Re: Inconsistent results postgresql |
| Дата | |
| Msg-id | CABuViOyExKnL1mAkBpurJKbmmvPihm+8LU=jG7MaKRcL1sED7A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Inconsistent results postgresql (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
Yes there was some users subscribed at different date than payment was made. So I used this to get the results on the daily basis :
SELECT date_trunc('day', payments.created_at) "day", SUM("payments"."amount") AS sum_id
FROM "payments"
INNER JOIN "users" ON "users"."id" = "payments"."user_id"
WHERE "payments"."currency" = 'gbp' AND (payments.refunded_date is null)
AND
(users.deleted_at is null)
AND
(users.subscribed_at between '2014-06-30 00:00:00.000000' and '2014-07-30 23:59:59.999999')
AND
("payments"."created_at" BETWEEN '2014-07-07 00:00:00.000000' AND '2014-07-07 23:59:59.999999')
GROUP BY 1
ORDER by 1 asc
So use the payment.created_at to for the current date and the range for the users.subscribed_at
On Thu, Jul 31, 2014 at 9:00 AM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 07/31/2014 05:44 AM, Emir Ibrahimbegovic wrote:So, did you find the cause?Thank you for your response guys.
--
Adrian Klaver
adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: