On Oct 24, 2004, at 4:13 PM, Pierre-Frédéric Caillaud wrote:
How can we sort intervals meaningfully in these conditions ? Can we ? In fact the value of an interval depends on the application, and intervals with months are in another 'world' than intervals with only seconds... same thing for years.
Added to this, I've been wondering whether '1 day'::interval is also problematic wrt daylight savings time or changing time zones. The whole thing seems pretty hairy to me.
Michael Glaesemann grzm myrealbox com
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
