Re: Building JSON objects - Mailing list pgsql-general

From Jan de Visser
Subject Re: Building JSON objects
Date
Msg-id 4312779.s9llolfXe9@wolverine
Whole thread Raw
In response to Re: Building JSON objects  (Eli Murray <ejmurra2@illinimedia.com>)
Responses Re: Building JSON objects  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: check data for datatype
Next
From: Adrian Klaver
Date:
Subject: Re: Building JSON objects