Vitaly Burovoy <vitaly.buro...@gmail.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers