Re: Building JSON objects - Mailing list 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 :-)