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

From Bruce Momjian
Subject Re: age() function?
Date
Msg-id 200201180554.g0I5s9R23085@candle.pha.pa.us
Whole thread Raw
In response to Re: age() function?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 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.

I guess if we knew the month we could do better.  :-)

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

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