>> BTW, that second value looks a whole lot like a poorly thought out >> substitute for 'infinity' ... >> regards, tom lane > > That's certainly an interesting comment and I'm open to suggestions! The > original db has two columns (from_timestamp, to_timestamp). I don't go for > NULL in the to_timestamp column. Alternatively, a timestamp very, very far > in the future can throw off query planners. Tom is telling you that there is a special "timestamp" 'infinity': alter table the_table alter column the_column set default tsrange(now()::timestamp without time zone, 'infinity'::timestamp without time zone); -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
