Re: Building JSON objects

From: Jan de Visser <jan(at)de-visser(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Building JSON objects
Date: 2015-03-27 18:31:01
Message-ID: 4312779.s9llolfXe9@wolverine
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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())

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arthur Silva 2015-03-27 18:36:16 Re: json-patch support?
Previous Message Raymond O'Donnell 2015-03-27 18:14:50 Re: check data for datatype