Re: Array_to_json remove brackets - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Array_to_json remove brackets
Date
Msg-id CAHyXU0xN=R_+w-D1=h_Eb=5vGmiR_y0kjuUE0c4+BF=kW0JOTA@mail.gmail.com
Whole thread Raw
In response to Array_to_json remove brackets  (Leonardo M. Ramé <l.rame@griensu.com>)
Responses Re: Array_to_json remove brackets  (Leonardo M. Ramé <l.rame@griensu.com>)
List pgsql-general
On Fri, Nov 13, 2015 at 7:20 AM, Leonardo M. Ramé <l.rame@griensu.com> wrote:
> Hi, is there a way to get an array converted to json without brackets?.
>
> I'm getting, for example [{"field": "value"}, {"field": "value"}] and I want
> to get this: {"field": "value"}, {"field": "value"}.

please supply an example.  Also,
{"field": "value"}, {"field": "value"}

is not valid json, so, basically, no.  But you could textually remove
them I guess but I'm thinking more context is needed to give a better
answer.

merlin


pgsql-general by date:

Previous
From: Leonardo M. Ramé
Date:
Subject: Array_to_json remove brackets
Next
From: "Doiron, Daniel"
Date:
Subject: Re: Does PostgreSQL ever create indexes on its own?