Hi Ivan,

On Mon, Jan 1, 2018 at 3:34 PM, Ivan E. Panchenko <
i.panche...@postgrespro.ru> wrote:

>
> select json_object_agg(gid, y) from
>     (
>          select gid, jsonb_agg(row_to_json(chat)) y
>          from chat
>          group by gid
>     ) x;
>
>
> 01.01.2018 16:41, Alexander Farber пишет:
>
>>
>> I have prepared a simple SQL Fiddle demonstrating my problem:
>> http://sqlfiddle.com/#!17/2c9c5/1
>>
>>
that is great, thank you!

Reply via email to