Re: age() function?

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: age() function?
Date: 2002-01-18 05:38:57
Message-ID: 20020118143857E.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > How come 10 mons == 9 mons 30 days?
>
> Because for purposes of comparisons, type interval assumes 1 month
> == 30 days (cf. interval_cmp_internal). Pretty grotty, I agree,
> but it's not easy to see how to do better.

Oh I see. Probably that's the reason why the standard does not allow
month-and-day-mixed interval.
--
Tatsuo Ishii

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2002-01-18 05:45:47 Re: tuptoaster.c must *not* use SnapshotAny
Previous Message Tom Lane 2002-01-18 05:27:50 Re: tuptoaster.c must *not* use SnapshotAny