BUG #10922: row_to_json creates invalid JSON for currecy lower then 1000.

From: karel(dot)knezourek(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #10922: row_to_json creates invalid JSON for currecy lower then 1000.
Date: 2014-07-11 04:06:53
Message-ID: 20140711040653.2776.16311@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 10922
Logged by: Karel Knezourek
Email address: karel(dot)knezourek(at)gmail(dot)com
PostgreSQL version: 9.4beta1
Operating system: linux
Description:

select version();
--"PostgreSQL 9.4devel on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.4.7 20120313 (Red Hat 4.4.7-4), 64-bit"
--"PostgreSQL 9.3.4, compiled by Visual C++ build 1600, 64-bit"

-- TEST CASE
CREATE TABLE test
(
currency money
);

INSERT INTO test(currency) SELECT '1.34'::float8::numeric::money;
INSERT INTO test(currency) SELECT '1000.34'::float8::numeric::money;
SELECT row_to_json(t) FROM (SELECT * FROM TEST) t;
--{"currency":1,34 Kč} NOT OK !!! it is not valid JSON without double quotes

--{"currency":"1 000,34 Kč"} OK

drop table test;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2014-07-11 04:21:57 Re: Missing file versions for a bunch of dll/exe files in Windows builds
Previous Message anuno1 2014-07-10 23:46:44 BUG #10919: Fix for BUG #9110: Fresh install of psqlodbc_09_03_0100-x64.zip fails