Re: Interval "1 month" is equals to interval "30 days" - WHY?

Craig Ringer wrote:
>> Of course this is not always correct.
>> But what should the result of
>>    INTERVAL '1 month' = INTERVAL '30 days'
>> be?  FALSE would be just as wrong.

> NULL? In all honesty, it's a reasonable fit for NULL in its
> "uncertain/unknowable" personality,  because two intervals that don't
> use the same time scales aren't truly comparable for equality.

Hmmm.  How would you define an ordering in that case?
And without an ordering, you couldn't use "btree" indexes
on interval columns, right?

Yours,
Laurenz Albe