Re: '1 year' = '360 days' ????

Tom Lane <tgl@sss.pgh.pa.us> writes:

> "Ricardo Perez Lopez" <ricpelo@hotmail.com> writes:
>> I have observed that, for PostgreSQL, one year is actually 360 days:
>
>> SELECT '1 year'::timestamp = '360 days'::timestamp;
>
>> ?column?
>> -------------
>>     t
>
> Nonsense.
>
> regression=# SELECT '1 year'::timestamp = '360 days'::timestamp;
> ERROR:  invalid input syntax for type timestamp: "1 year"
>
> How about telling us what you *really* did, instead of posting faked
> examples?

FWIW:

template1=# select '1 year'::interval = '360 days'::interval;
 ?column?
----------
 t
(1 row)

template1=# select '1 year'::interval = '365 days'::interval;
 ?column?
----------
 f
(1 row)

template1=# select version();
                               version
---------------------------------------------------------------------
 PostgreSQL 7.4.5 on i686-pc-linux-gnu, compiled by GCC egcs-2.91.66
(1 row)

-Doug