On Tue, 2022-07-05 at 17:29 +0900, Tatsuo Ishii wrote:
> I found that provolatile attribute of to_timestamp in pg_proc is
> wrong:
>
> test=# select provolatile, proargtypes from pg_proc where proname = 'to_timestamp' and proargtypes[0] = 701;
> provolatile | proargtypes
> -------------+-------------
> i | 701
> (1 row)
>
> 'i' (immutable) is clearly wrong s
Are you sure? I'd say that "to_timestamp(double precision)" always
produces the same timestamp for the same argument. What changes with
the setting of "timezone" is how that timestamp is converted to a
string, but that's a different affair.
Yours,
Laurenz Albe