From: | email(at)andersonloyola(dot)com(dot)br |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #8676: Bug Money JSON |
Date: | 2013-12-11 14:30:04 |
Message-ID: | E1Vqknc-0007nO-5S@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
The following bug has been logged on the website:
Bug reference: 8676
Logged by: Anderson Cristian da Silva
Email address: email(at)andersonloyola(dot)com(dot)br
PostgreSQL version: 9.3.2
Operating system: Centos 6.3 (Final)
Description:
Failed to convert money to json EX.:
postgres=# SELECT to_json(a) FROM (VALUES(1000::money)) a(salario);
to_json
-----------------------
{"salario":$1,000.00}
(1 row)
postgres=# SELECT to_json(a)->'salario' FROM (VALUES(1000::money))
a(salario);
ERROR: invalid input syntax for type json
DETAIL: Token "$" is invalid.
CONTEXT: JSON data, line 1: {"salario":$...
From | Date | Subject | |
---|---|---|---|
Next Message | fabio.pasqualini | 2013-12-11 19:01:54 | BUG #8677: char(n) - bad limit with arrays of composite type |
Previous Message | Devrim GÜNDÜZ | 2013-12-11 12:21:12 | Re: BUG #8675: Missing 9.3 RPMs for tail_n_mail in official yum repo |
From | Date | Subject | |
---|---|---|---|
Next Message | Kohei KaiGai | 2013-12-11 14:32:27 | Re: Custom Scan APIs (Re: Custom Plan node) |
Previous Message | Florian Pflug | 2013-12-11 14:28:51 | Re: ANALYZE sampling is too good |