Folks,
In to_char(), the new-in-9.4 'OF' feature is straight-up broken, to
wit:
set timezone to 'America/Caracas'; select to_char(now(), 'OF');
SET
to_char
âââââââââ
-04:-30
^OK ^NOT OK
Interestingly, in git master as of yesterday, it's broken in an
entirely different way:
set timezone to 'America/Caracas'; select to_char(now(), 'OF');
SET
to_char
âââââââââ
-004:30
^ What's this extra zero doing here?
(1 row)
Fractional offset time zones should probably be in our regression test
suite for this feature.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david.fetter@gmail.com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate