Re: Building JSON objects
От | Jan de Visser |
---|---|
Тема | Re: Building JSON objects |
Дата | |
Msg-id | 2956400.k1a31xIMRa@wolverine обсуждение исходный текст |
Ответ на | Re: Building JSON objects ("David G. Johnston" <david.g.johnston@gmail.com>) |
Ответы |
Re: Building JSON objects
|
Список | pgsql-general |
On March 27, 2015 11:38:42 AM David G. Johnston wrote: > On Fri, Mar 27, 2015 at 11:31 AM, Jan de Visser <jan@de-visser.net> wrote: > > 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()) > > or.. > > INSERT INTO json(data) SELECT json_build_object(SELECT DISTINCT dep...) > > David J. Serves me right for bringing the snark without properly reading the OP :-)
В списке pgsql-general по дате отправления: