Accept "+infinity" in date and timestamp[tz] input.
Tom Lane <tgl@sss.pgh.pa.us>
Accept "+infinity" in date and timestamp[tz] input. The float and numeric types accept this variant spelling of "infinity", so it seems like the datetime types should too. Vik Fearing, some cosmetic mods by me Discussion: https://postgr.es/m/d0bef637-2dbd-0a5d-e539-48243b6f6c5e@postgresfriends.org
Files
| Path | Change | +/− |
|---|---|---|
| src/backend/utils/adt/datetime.c | modified | +1 −0 |
| src/test/regress/expected/date.out | modified | +6 −0 |
| src/test/regress/expected/timestamp.out | modified | +6 −0 |
| src/test/regress/expected/timestamptz.out | modified | +6 −0 |
| src/test/regress/sql/date.sql | modified | +2 −0 |
| src/test/regress/sql/timestamp.sql | modified | +2 −0 |
| src/test/regress/sql/timestamptz.sql | modified | +2 −0 |
Discussion
- +infinity for dates and timestamps 5 messages · 2023-01-01