Re: timestamp out of range while casting return value to function's return type

Hi Tom

Thanks for replying so fast. You are absolutely right.

I changed the code file but failed to install it. :-( I am sorry for
not checking the obvious.

Kind regards

Thiemo

Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> writes:
>> I created a function that ought to return a timestamptz (another
>> likewise timestamp) but calling it, I get mentionied error. What do I
>> miss?
>
> Whether that:
>
>> return '294277-01-01 00:59:59.999999'::timestamptz;
>
> is in range or not depends on your timezone setting. It would
> be considered in-range in UTC+1 or further east (so that the date
> wraps back to 294276AD); in or west of Greenwich, not so much.
>
>> I tried to return a timestamp of the year 2000 to no avail.
>
> Hardly ...
>
> regards, tom lane

--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Handys: +41 78 947 36 21 | +49 1578 772 37 37
Tox-Id:
B7282A9E31D944DDAD1ECC5B33C36AAE80B32D119AB7391D602C937A65E8CA0625C495C5322B