Marko Tiikkaja <marko(at)joh(dot)to> writes:
> So I got into thinking whether it would make sense to provide a new
> function, say, to_char_at_timezone() to solve this problem. For example:
> ...
> Any thoughts? The patch is quite trivial.
I'm not convinced that it's all that trivial. Is the input timestamp or
timestamptz, and what's the semantics of that exactly (ie what timezone
rotation happens)? One's first instinct is often wrong in this area.
regards, tom lane