Re: BUG #8398: to_json(''::hstore) gives invalid JSON

On Mon, Aug 26, 2013 at 06:00:37PM +0000, martin(dot)kevin(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8398
> Logged by: Kevin Martin
> Email address: martin(dot)kevin(at)gmail(dot)com
> PostgreSQL version: 9.3rc1
> Operating system: Ubuntu 10.04
> Description:
>
> to_json() returns an invalid JSON value when called on an empty hstore
> value. The first two statements below behave as expected, the third (with an
> empty hstore) fails:
>
>
> config_test=# SELECT to_json(q) FROM (SELECT '' AS v) AS q;
> to_json
> ----------
> {"v":""}
> (1 row)
>
>
> config_test=# SELECT to_json(q) FROM (SELECT ARRAY[]::INT[] AS v) AS q;
> to_json
> ----------
> {"v":[]}
> (1 row)
>
>
> config_test=# SELECT to_json(q) FROM (SELECT ''::HSTORE AS v) AS q;
> to_json
> ---------
> {"v":}
> (1 row)

I see different/better(?) output in git head:

SELECT to_json(q) FROM (SELECT ''::HSTORE AS v) AS q;
to_json
----------
{"v":{}}
(1 row)

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +