On Mon, Oct 19, 2015 at 10:25:53AM -0400, David G. Johnston wrote:
> On Mon, Oct 19, 2015 at 9:00 AM, <stepanperlov@gmail.com> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference:Â Â Â 13687
> Logged by:Â Â Â Â Â Stepan
> Email address:Â Â Â stepanperlov@gmail.com
> PostgreSQL version: 9.4.5
> Operating system:Â Â Ubuntu 14.04.1 LTS
> Description:
>
> SELECT row_to_json(t)
> Â FROM (SELECT '-infinity'::timestamptz) t
>
>
> âWhat do you see happening and what do you think should happen (and why)?
Well, the output I see is:
SELECT row_to_json(t)
FROM (SELECT '-infinity'::timestamptz) t ;
row_to_json
----------------------------
{"timestamptz":"infinity"}
I assume the user expects positive infinity.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription +