+/- infinity
value for date
/timestamp
/timestamp with time zone
#4515
Labels
+/- infinity
value for date
/timestamp
/timestamp with time zone
#4515
Is your feature request related to a problem? Please describe.
In PostgreSQL, the types
date
/timestamp
/timestamp with time zone
support specialinfinity
and-infinity
values, just likereal
/double precision
/decimal
.time
cannot be infinity.interval
cannot be infinity either. But there do exists a checking functionisfinite ( interval ) → boolean
, which is "currently always true" according to PostgreSQL doc.Describe the solution you'd like
Just like
Decimal
, make the wrapper type an enum rather than newtype. Specially,timestamp with time zone
is not wrapped right now.Describe alternatives you've considered
Nothing yet. Suggestions are welcome.
Additional context
Just raising awareness of this difference. No urgent need for implementation.
The text was updated successfully, but these errors were encountered: