'13 months ago'::reltime - Mailing list pgsql-sql

From Albert REINER
Subject '13 months ago'::reltime
Date
Msg-id 20010501143643.A929@frithjof
Whole thread Raw
Responses Re: '13 months ago'::reltime  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Saluton,

I do not quite understand the following:

,----
| albert=> select '13 months ago'::reltime;
|     ?column?
| ---------------------
|  1 year 25 00:00 ago
| (1 row)
| 
| albert=> select '13 months ago'::interval;
|       ?column?
| ------------------------
|  1 year 1 mon 00:00 ago
| (1 row)
| 
| albert=> select version();
|                 version
| --------------------------------------------------------------------
|  PostgreSQL 7.0.2 on i586-pc-linux-gnulibc1, compiled by gcc 2.95.1
| (1 row)
`----

Shouldn't 13 months be 1 year and 1 month even for reltime?

Somewhat puzzled,

Albert.



pgsql-sql by date:

Previous
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: How to encode and decode password in pgsql !!
Next
From: "Josh Berkus"
Date:
Subject: Re: How to encode and decode password in pgsql !!