Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp - Mailing list pgsql-bugs

From Bruce Momjian
Subject Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp
Date
Msg-id 20151019151248.GC24392@momjian.us
Whole thread Raw
In response to Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp
List pgsql-bugs
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                             +

pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp
Next
From: rucsoftsec@163.com
Date:
Subject: BUG #13688: lack of return value in r_mark_regions()