Andrew - Supernews <andrew+nonews@supernews.com> writes:
> I did some analysis for this one when it was mentioned just now in the irc
> chan. I can reproduce on 7.4.x as follows:
> test=> set timezone to 'America/Buenos_Aires';
> SET
> test=> select age(date '2005-05-05', date '1964-05-05');
> age
> -----------------------------------
> 40 years 11 mons 30 days 23:00:00
> (1 row)
Not for me --- I get "41 years" for that case. Since 7.4 depends on the
OS' timezone code, this is presumably OS-dependent. I'm using Fedora
Core 3, which has ... hmm ...
$ rpm -qf /usr/share/zoneinfo/America/Buenos_Aires
tzdata-2005f-1.fc3
... a pretty recent zoneinfo package. What's yours?
regards, tom lane