Re: BUG #14558: to_timestamp() format lies about supporting timezone

On Mon, Feb 20, 2017 at 8:11 AM, <coladict(at)gmail(dot)com> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 14558
> Logged by: Jordan Gigov
> Email address: coladict(at)gmail(dot)com
> PostgreSQL version: 9.6.2
> Operating system: irrelevant
> Description:
>
> postgres=# SELECT to_timestamp('2017-02-20 16:00:27.989808+02', 'YYYY-MM-DD
> HH24:MI:SS.SSSSOF')::timestamp with time zone;
> ERROR: "TZ"/"tz"/"OF" format patterns are not supported in to_date
>
>
​I'm not a maintainer. Or any kind of an official "expert". But I'm
wondering if the above is really a bug. From reading the documentation on:
https://www.postgresql.org/docs/current/static/functions-datetime.html, it
seems to me to say that to_timestamp() only takes one parameter, which is a
double precision number (not a string). But the following worked well for
me:

tsh009=# SELECT '2017-02-20 16:00:27.989808+02'::timestamp;
timestamp
----------------------------
2017-02-20 16:00:27.989808
(1 row)
​
Or was this an enhancement request?

--
"Irrigation of the land with seawater desalinated by fusion power is
ancient. It's called 'rain'." -- Michael McClary, in alt.fusion

Maranatha! <><
John McKown