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