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:
Thank you for your response guys.

So, did you find the cause?

--
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Inconsistent results postgresql
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Inconsistent results postgresql