Horton

Re: +infinity for dates and timestamps

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

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Vik Fearing <vik@postgresfriends.org>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, jian he <jian.universality@gmail.com>
Date: 2023-01-01T05:24:30Z
Lists: pgsql-hackers 
Vik Fearing <vik@postgresfriends.org> writes:
> It has always annoyed me that we can't write '+infinity' for dates and 
> timestamps and get the OCD satisfaction of making our queries line up 
> with '-infinity'.

+1, since it works for numerics it should work for these types too.
(I didn't read the patch though.)

			regards, tom lane

Commits

  1. Accept "+infinity" in date and timestamp[tz] input.