Nitin Jadhav <nitinjadhavpostg...@gmail.com> writes: > While understanding the behaviour of the to_char() function as > explained in [1], I observed that some patterns related to time zones > do not display values if we mention in lower case. As shown in the > sample output [2], time zone related patterns TZH, TZM and OF outputs > proper values when specified in upper case but does not work if we > mention in lower case. But other patterns like TZ, HH, etc works fine > with upper case as well as lower case.
> I would like to know whether the current behaviour of TZH, TZM and OF > is done intentionally and is as expected. AFAICS, table 9.26 specifically shows which case-variants are supported. If there are some others that happen to work, we probably shouldn't remove them for fear of breaking poorly-written apps ... but that does not imply that we need to support every case-variant. regards, tom lane