Re: Strange timezone 'math' in 9.6.8

Thank you for explantations.

Best, Ervin.

On 28 March 2018 at 17:17, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> writes:
>> Ervin Weber wrote:
>>> staging=# select now(), now() at time zone 'fubar+167';
>>> [works]
>>> staging=# select now(), now() at time zone 'fubar+168';
>>> ERROR: time zone "fubar+168" not recognized
>
>> The cause of the error is the following code in src/timezone/localtime.c,
>> in function "getsecs":
>
> Also note that that isn't our code; it's lock stock and barrel from the
> IANA tzcode distribution,
> https://www.iana.org/time-zones
>
> So we are (probably) not the only software that will behave like this.
>
> regards, tom lane