Horton

Disallow infinite endpoints in generate_series() for timestamps.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: eafdf9de06e9b60168f5e47cedcfceecdc6d4b5f
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2022-04-20T22:08:23Z
Releases: 15.0 
Disallow infinite endpoints in generate_series() for timestamps.

Such cases will lead to infinite loops, so they're of no practical
value.  The numeric variant of generate_series() already threw error
for this, so borrow its message wording.

Per report from Richard Wesley.  Back-patch to all supported branches.

Discussion: https://postgr.es/m/91B44E7B-68D5-448F-95C8-B4B3B0F5DEAF@duckdblabs.com

Files

PathChange+/−
src/backend/utils/adt/timestamp.c modified +28 −0
src/test/regress/expected/timestamp.out modified +49 −0
src/test/regress/expected/timestamptz.out modified +49 −0
src/test/regress/sql/timestamp.sql modified +15 −0
src/test/regress/sql/timestamptz.sql modified +15 −0

Discussion