| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Joseph Adams <joeyadams3(dot)14159(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, magnus(at)hagander(dot)net |
| Subject: | Re: JSON manipulation functions |
| Date: | 2010-05-14 15:33:12 |
| Message-ID: | 201005141533.o4EFXC504326@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc G. Fournier | 2010-05-14 15:37:34 | Re: List traffic |
| Previous Message | Bruce Momjian | 2010-05-14 15:30:46 | Re: HS/SR Assert server crash |