| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | knut(at)wehrle(dot)org |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #14213: bug in hstore_to_json_loose() function |
| Date: | 2016-06-24 16:04:07 |
| Message-ID: | 20160624160407.GA275457@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
knut(at)wehrle(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | zzia88 | 2016-06-24 17:32:59 | BUG #14214: i am enable to upload .xlsx file in my postgres database. |
| Previous Message | Tom Lane | 2016-06-24 14:42:55 | Re: BUG #14213: bug in hstore_to_json_loose() function |