age() function? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject age() function?
Date
Msg-id 20020118134745M.t-ishii@sra.co.jp
Whole thread Raw
Responses Re: age() function?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi, I see followings in current:

create table t2 (t date primary key)
[insert some data into t2]select *,age(t) from t2 where age(t) = '9 mons 30 days'::interval;    t      |      age

------------+----------------2001-03-18 | 10 mons2001-03-19 | 9 mons 30 days
(2 rows)

How come 10 mons == 9 mons 30 days?
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Bug in pg_dump/restore -o
Next
From: Bruce Momjian
Date:
Subject: Re: tuptoaster.c must *not* use SnapshotAny