Postgres Pro
Downloads
Home   >   mailing lists

Re: age() function? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: age() function?
Date
Msg-id 4343.1011330672@sss.pgh.pa.us
Whole thread Raw
In response to age() function?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: age() function?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Re: age() function?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> 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.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: tuptoaster.c must *not* use SnapshotAny
Next
From: Hiroshi Inoue
Date:
Subject: Re: tuptoaster.c must *not* use SnapshotAny