Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #10922: row_to_json creates invalid JSON for currecy lower then 1000. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #10922: row_to_json creates invalid JSON for currecy lower then 1000.
Date
Msg-id 21420.1405115354@sss.pgh.pa.us
Whole thread Raw
In response to BUG #10922: row_to_json creates invalid JSON for currecy lower then 1000.  (karel.knezourek@gmail.com)
List pgsql-bugs
Tree view 
karel.knezourek@gmail.com writes:
> -- 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

Thanks for the report!  I can't reproduce this on HEAD.  I think it
should have been resolved by commit 0ca6bda8e, but that was done a
couple of days before we stamped 9.4beta1.  Are you sure this is
exactly beta1, and not some slightly earlier version?  Your
version() output looks like it predates beta1 ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Compile fails on AIX 6.1
Next
From: Michael Paquier
Date:
Subject: Re: Missing file versions for a bunch of dll/exe files in Windows builds