Sam Mason <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general