| 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: | Whole Thread | Raw Message | 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;
| 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 |