Re: [GENERAL] JSON "pretty" and selecting nested JSON fields

2015-03-30 Thread Merlin Moncure
On Mon, Mar 30, 2015 at 3:30 PM, Adrian Klaver wrote: > On 03/30/2015 10:54 AM, Deven Phillips wrote: >> >> Hi all, >> >> I have a query which selects several rows of data, and contained in >> one of those rows is some aggregated JSON data. I am using row_to_json() >> to make the whole output

Re: [GENERAL] JSON "pretty" and selecting nested JSON fields

2015-03-30 Thread Adrian Klaver
On 03/30/2015 10:54 AM, Deven Phillips wrote: Hi all, I have a query which selects several rows of data, and contained in one of those rows is some aggregated JSON data. I am using row_to_json() to make the whole output JSON and I am providing "true" for pretty formatting of the JSON. The p

Re: [GENERAL] JSON "pretty" and selecting nested JSON fields

2015-03-30 Thread Merlin Moncure
On Mon, Mar 30, 2015 at 12:54 PM, Deven Phillips wrote: > Hi all, > > I have a query which selects several rows of data, and contained in one > of those rows is some aggregated JSON data. I am using row_to_json() to make > the whole output JSON and I am providing "true" for pretty formatting o

Re: [GENERAL] JSON "pretty" and selecting nested JSON fields

2015-03-30 Thread Deven Phillips
Here's an example of the JSON output I am getting: {"customer_code":"abcd", "vdc":1241, "vmid":114778, "uuid":"421ea391-b292-ca2e-9a3a-6da3037748c8", "name":"vmname", "os":"Red Hat Enterprise Linux 6 (64-bit)", "service_type":"CU", "template_name":"", "self":" https://mysite.mydomain.tld/v