Re: JSON manipulation functions - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: JSON manipulation functions
Date
Msg-id 201005141533.o4EFXC504326@momjian.us
Whole thread Raw
In response to JSON manipulation functions  (Joseph Adams <joeyadams3.14159@gmail.com>)
Responses Re: JSON manipulation functions
Re: JSON manipulation functions
List pgsql-hackers
Joseph Adams wrote:
> == array/object conversion ==
> 
> The json_object function converts a tuple to a JSON object.  If there
> are duplicate column names, there will be duplicate keys in the
> resulting JSON object.
> 
> json_object([content [AS name] [, ...]]) returns json
> 
> Likewise, the json_array function converts a tuple to a JSON array.
> Column names are ignored.
> 
> json_array([content [AS name] [, ...]]) returns json

Do you see any problems with the fact that JSON arrays can use mixed
data types, e.g.:
[ 1, 2, 'hi', false]

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: HS/SR Assert server crash
Next
From: "Marc G. Fournier"
Date:
Subject: Re: List traffic