Yeah guys from http://2ndquadrant.com/ are good, especially if you have a
large dataset and your business depends heavily on it. But I assume if
their management wants to cut costs, they expect that their employees will
be able to handle completely new technology with not much prior experience
(fir
Hello all,
I've got two queries which should produce the same results but they don't
for some reason, please consider these :
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
"
Thank you for your response guys.
On Wed, Jul 30, 2014 at 9:25 PM, Chris Curvey wrote:
>
>
>
> On Wed, Jul 30, 2014 at 8:41 PM, Emir Ibrahimbegovic <
> emir.ibrahimbego...@gmail.com> wrote:
>
>> Hello all,
>>
>> I've got two queries which should
:00.00' and '2014-07-30
23:59:59.99')
AND
("payments"."created_at" BETWEEN '2014-07-07 00:00:00.00' AND
'2014-07-07 23:59:59.99')
GROUP BY 1
ORDER by 1 asc
So use the payment.created_at to for the current date and the range for the
us
