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.
