On Fri, Mar 27, 2015 at 11:31 AM, Jan de Visser <j...@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.
