| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Hitoshi Harada <umi(dot)tanuki(at)gmail(dot)com> |
| Cc: | "David E(dot) Wheeler" <david(at)kineticode(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: PATCH: Add hstore_to_json() |
| Date: | 2010-01-04 00:30:05 |
| Message-ID: | 4B41368D.60906@dunslane.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hitoshi Harada wrote:
> 2010/1/4 David E. Wheeler <david(at)kineticode(dot)com>:
>
>> On Jan 3, 2010, at 11:40 AM, Andrew Dunstan wrote:
>>
>>
>>> We allow composites as fields. The biggest mismatch in the type model is probably w.r.t arrays. JSON arrays can be heterogenous and non-rectangular, AIUI.
>>>
>> Cool, that sounds right.
>>
>
> Does it mean you should create composite type to create anonymous JSON?
>
>
No, not in the least. We should still store JSON as text. We should
simply be able to convert a JSON value to a record of an existing type
(providing it has the right shape) and a record (of any shape) to JSON.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Takahiro Itagaki | 2010-01-04 01:34:42 | Re: Verifying variable names in pgbench |
| Previous Message | Hitoshi Harada | 2010-01-04 00:18:45 | Re: PATCH: Add hstore_to_json() |