Re: [GENERAL] Practical Application

2015-12-14 Thread Emir Ibrahimbegovic
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

Re: [GENERAL] Inconsistent results postgresql

2014-07-31 Thread Emir Ibrahimbegovic
Thank you for your response guys. On Wed, Jul 30, 2014 at 9:25 PM, Chris Curvey ch...@chriscurvey.com 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 produce the same results but they don't

Re: [GENERAL] Inconsistent results postgresql

2014-07-31 Thread Emir Ibrahimbegovic
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.kla...@aklaver.com wrote: On 07/31/2014 05:44 AM, Emir Ibrahimbegovic wrote: Thank you for your response guys. So, did you find

[GENERAL] Inconsistent results postgresql

2014-07-30 Thread Emir Ibrahimbegovic
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 payments.currency