Re: PATCH: Add hstore_to_json()
David E. Wheeler <david@kineticode.com>
From: "David E. Wheeler" <david@kineticode.com>
To: Hitoshi Harada <umi.tanuki@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, Peter Eisentraut <peter_e@gmx.net>, Robert Haas <robertmhaas@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2010-01-04T03:21:29Z
Lists: pgsql-hackers
On Jan 3, 2010, at 4:18 PM, Hitoshi Harada wrote:
> That sounds good and seems possible, as far as operator returns JSON
> always. Perhaps every JSON fetching returns JSON even if the result
> would be a number. You can cast it.
>
> % SELECT ('{"foo":{"bar":["a","b","c"]}}' -> '["foo"][1]')::text;
> 1
> -----
> b
No, because 'b' isn't valid JSON. So if we want an interface that returns scalars, they can't be JSON.
Best,
David