Re: BUG #14213: bug in hstore_to_json_loose() function - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #14213: bug in hstore_to_json_loose() function
Date
Msg-id 20160624160407.GA275457@alvherre.pgsql
Whole thread Raw
In response to BUG #14213: bug in hstore_to_json_loose() function  (knut@wehrle.org)
List pgsql-bugs
knut@wehrle.org wrote:

> I get an arrow with the following command:
>
> select hstore_to_json_loose(hstore('"date"=>"2016-06-24"'))->>'date'
>
> The problem is, that the function is not generating an ISO date string but a
> mathematical formula: 2016 - 06 - 24 = 1986!
>
> Probably this is the intended way to handle this kind of data, but then the
> '->>' operator would be buggy.

Knut replied to the moderation notice to indicate that 9.4.8 fixed the
issue, and asked for a version log.  Here's the git repository:
https://git.postgresql.org/gitweb/?p=postgresql.git

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #14213: bug in hstore_to_json_loose() function
Next
From: zzia88@gmail.com
Date:
Subject: BUG #14214: i am enable to upload .xlsx file in my postgres database.