> > type <date>" or some such. However the best would be to use > > "-infinity". > > +/- infinity are only available as timestamps, not dates. Hm, any particular reason why ? Apart from no one having gotten around to doing it...
Strange enough, on 7.4.6 I am unsure as to how to interpret the output of: select ('2000-10-10'::date < 'infinity'::timestamp::date); ?column? ---------- (1 row) Further testing shows it seems to be of type boolean. Is it NULL ? Coalesce did not help. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings