Re: Building JSON objects

Поиск
Список
Период
Сортировка
От Jan de Visser
Тема Re: Building JSON objects
Дата
Msg-id 4312779.s9llolfXe9@wolverine
обсуждение исходный текст
Ответ на Re: Building JSON objects  (Eli Murray <ejmurra2@illinimedia.com>)
Ответы Re: Building JSON objects
Список pgsql-general
On March 27, 2015 01:12:52 PM Eli Murray wrote:
> ERROR:  syntax error at or near "json_build_object"
> LINE 1: insert into json(data) json_build_object(SELECT DISTINCT dep...

You may want to review the syntax of the INSERT command, i.e. this doesn't
have anything to do with JSON:

INSERT INTO foo ( bar, baz, quux, froz ) VALUES (NULL, 12, 'box', now())


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