Sam Mason <sam@samason.me.uk> writes:
> I sometimes find it easier to store ranges like this with having the
> open ends at infinity. This is easier with timestamps as they have
> magic 'infinity' values in PG (both positive and negative). Values of
> date type don't have any special values like this which makes things a
> bit more awkward.
Just FYI, date does have +/-infinity as of 8.4.
regards, tom lane