> (I'm asking because of an issue that came up about intervals that were > "equal but not identical.")
1) Can you provide an example?
Here's an example. Note that they come out formatted differently with to_char, but evaluate as equal. The explanation(1) was that they were Equal but not Identical. I was thinking getting the raw data about how they are stored would get at the identicality issue:
WITH inters AS ( SELECT '1 day 2 hours'::interval AS i1, '26 hours'::interval AS i2 ) SELECT *, to_char(i1,'HH24:MM:SS') AS i1_char, to_char(i2,'HH24:MM:SS') AS i2_char, i1=i2 AS "Equal?" FROM inters;