Tom Lane <[EMAIL PROTECTED]> writes:
> "Ricardo Perez Lopez" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
