Horton

Reject combining "epoch" and "infinity" with other datetime fields.

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

View on postgr.es
Commit: bcc704b52490492e6bd73c4444056b3e9644504d
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2023-03-09T21:49:03Z
Releases: 16.0 
Reject combining "epoch" and "infinity" with other datetime fields.

Datetime input formerly accepted combinations such as
'1995-08-06 infinity', but this seems like a clear error.
Reject any combination of regular y/m/d/h/m/s fields with
these special tokens.

Joseph Koshakow, reviewed by Keisuke Kuroda and myself

Discussion: https://postgr.es/m/CAAvxfHdm8wwXwG_FFRaJ1nTHiMWb7YXS2YKCzCt8Q0a2ZoMcHg@mail.gmail.com

Files

PathChange+/−
src/backend/utils/adt/datetime.c modified +25 −15
src/test/regress/expected/horology.out modified +85 −0
src/test/regress/sql/horology.sql modified +23 −0

Discussion