Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qo5bI-0007Lg-DT for pgsql-general@arkaria.postgresql.org; Wed, 04 Oct 2023 17:23:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qo5aH-001dm0-3i for pgsql-general@arkaria.postgresql.org; Wed, 04 Oct 2023 17:22:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qo5aG-001dlq-Oq for pgsql-general@lists.postgresql.org; Wed, 04 Oct 2023 17:22:53 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qo5aF-00021n-1E for pgsql-general@lists.postgresql.org; Wed, 04 Oct 2023 17:22:52 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 394HMna52605700; Wed, 4 Oct 2023 13:22:49 -0400 From: Tom Lane To: Lincoln Swaine-Moore cc: Marian Wendt , pgsql-general@lists.postgresql.org Subject: Re: Strategies for converting UTC data to local windows for arbitrary resolutions and timezones In-reply-to: References: <2582288.1696428710@sss.pgh.pa.us> <13eb1e62-9c00-4878-bb82-ef003eca884c@yahoo.com> <2602231.1696438458@sss.pgh.pa.us> Comments: In-reply-to Lincoln Swaine-Moore message dated "Wed, 04 Oct 2023 13:10:56 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2605698.1696440169.1@sss.pgh.pa.us> Date: Wed, 04 Oct 2023 13:22:49 -0400 Message-ID: <2605699.1696440169@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Lincoln Swaine-Moore writes: > Excellent, thank you. So just to be explicit here, I could either run this > function, or set/run my query/set back, with the same behavior/safety > guarantees as if I was using the generate_series function with timezone > from v16? 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. regards, tom lane