I wrote: > Cool. I've pushed the patch. Hmm ... buildfarm's not entirely happy [1][2][3]:
diff -U3 /home/nm/farm/gcc64/HEAD/pgsql.build/src/test/regress/expected/interval.out /home/nm/farm/gcc64/HEAD/pgsql.build/src/test/regress/results/interval.out --- /home/nm/farm/gcc64/HEAD/pgsql.build/src/test/regress/expected/interval.out 2022-04-03 04:56:32.000000000 +0000 +++ /home/nm/farm/gcc64/HEAD/pgsql.build/src/test/regress/results/interval.out 2022-04-03 05:23:00.000000000 +0000 @@ -1465,7 +1465,7 @@ LINE 1: select interval 'PT2562047788.1:00:54.775807'; ^ select interval 'PT2562047788:01.:54.775807'; - ERROR: interval field value out of range: "PT2562047788:01.:54.775807" + ERROR: invalid input syntax for type interval: "PT2562047788:01.:54.775807" LINE 1: select interval 'PT2562047788:01.:54.775807'; ^ -- overflowing with fractional fields - SQL standard format What do you make of that? I'm betting that strtod() works a bit differently on those old platforms, but too tired to look closer tonight. regards, tom lane [1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=sungazer&dt=2022-04-03%2004%3A56%3A34 [2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hoverfly&dt=2022-04-03%2000%3A51%3A50 [3] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=anole&dt=2022-04-03%2000%3A32%3A10