Vitaly Burovoy <vitaly(dot)burovoy(at)gmail(dot)com> writes:
> I'm writing another patch for timestamps and while I tried to cover
> corner-cases I found out there is an ability to get
> "Infinity"::timestamptz via defining it by a specific (but not
> "Infinity") value:
> postgres=# SELECT '294277-01-09 04:00:54.775807+00'::timestamptz; -- Inf???
> timestamptz
> -------------
> infinity
> (1 row)
> I could not find a way to get "-Infinity" by similar way.
> Is it feature or a bug?
It's a bug. Probably related to the fact that "Infinity" is represented
as INT_MAX in the case of integer timestamps.
regards, tom lane