Relaxing NaN/Infinity restriction in JSON fields

From: Mitar <mmitar(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Relaxing NaN/Infinity restriction in JSON fields
Date: 2019-05-06 19:55:41
Message-ID: CAKLmikP5pOgB6y_m4mVbpQTuz=Gdkv60s69gYSrA42Mh0oLngw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

When migrating from MongoDB to PostgreSQL one thing which just
surprised me now is that I cannot store NaN/Infinity in JSON fields. I
know that standard JSON restricts those values, but they are a very
common (and welcome) relaxation. What are prospects of this
restriction being lifted? It is really sad that one cannot stores
directly all IEEE 754 double precision floating point values.

Mitar

--
http://mitar.tnode.com/
https://twitter.com/mitar_m

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-05-06 20:21:36 Re: Relaxing NaN/Infinity restriction in JSON fields
Previous Message Ron 2019-05-06 19:53:45 Re: Postgres for SQL Server users