age() function?

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: age() function?
Date: 2002-01-18 04:47:45
Message-ID: 20020118134745M.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 mons
2001-03-19 | 9 mons 30 days
(2 rows)

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2002-01-18 05:10:15 Re: tuptoaster.c must *not* use SnapshotAny
Previous Message Bruce Momjian 2002-01-18 04:42:14 pg_upgrade