Along with the discussed change of the return type of EXTRACT from float8 to numeric [0], I was looking around what other date/time APIs might be using float arguments or return values. The only thing left appears to be the functions make_time, make_timestamp, make_timestamptz, and make_interval, which take an argument specifying the seconds, which has type float8 right now. I'm proposing the attached patch to change that to numeric.
Can we change the arguments, as proposed here, or do we need to add separate overloaded versions and leave the existing versions in place?
What this change does with views. Can it break upgrade by pg_upgrade?