Andrew - Supernews <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])