[GENERAL] JSON pretty and selecting nested JSON fields

2015-03-30 Thread Deven Phillips
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 problem that I am seeing is that they nested JSON

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:

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 deven.phill...@gmail.com 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

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

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 adrian.kla...@aklaver.com 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