BUG #8676: Bug Money JSON

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":$...

Responses

Browse pgsql-bugs by date

  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

Browse pgsql-hackers by date

  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