Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones

Lincoln Swaine-Moore <lswainemoore@gmail.com>

From: Lincoln Swaine-Moore <lswainemoore@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Marian Wendt <marian.wendt@yahoo.com>, pgsql-general@lists.postgresql.org
Date: 2023-10-04T17:35:51Z
Lists: pgsql-general
> Yeah.  One thing to keep in mind is that that might have different
> behavior in terms of the evaluation of the arguments to the function,
> ie which timezone setting is your input parsed according to.

I see. You mean, in the event that it doesn't conform to an entry in
`pg_timezone_names`? I do have control over the possible options the user
can provide, so it should be straightforward to make sure those all have
entries.

Thanks,
Lincoln