That works! Thanks!
On Fri, May 30, 2014 at 11:59 AM, Merlin Moncure wrote:
> On Fri, May 30, 2014 at 11:16 AM, Chris Hanks
> wrote:
>> I'm using a JSON column to store some aggregate data, like so:
>>
>> UPDATE courses_table
>> SET aggregates = agg.aggregates
>> FROM (
>> SELE
On Fri, May 30, 2014 at 11:16 AM, Chris Hanks
wrote:
> I'm using a JSON column to store some aggregate data, like so:
>
> UPDATE courses_table
> SET aggregates = agg.aggregates
> FROM (
> SELECT course_id, row_to_json(sub) AS aggregates
> FROM (
> SELECT course_id,
I'm using a JSON column to store some aggregate data, like so:
UPDATE courses_table
SET aggregates = agg.aggregates
FROM (
SELECT course_id, row_to_json(sub) AS aggregates
FROM (
SELECT course_id, avg(rating) AS rating, sum(reviews_count) AS
reviews_count,
