Re: Query about time zone patterns in to_char

Nitin Jadhav <nitinjadhavpostgres(at)gmail(dot)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