Horton

Re: generate_series for timestamptz and time zone problem

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gurjeet Singh <gurjeet@singh.im>
Cc: Przemysław Sztoch <przemyslaw@sztoch.pl>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2023-01-30T07:28:54Z
Lists: pgsql-hackers 
Gurjeet Singh <gurjeet@singh.im> writes:
> On Sat, Nov 12, 2022 at 10:44 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I looked over the v5 patch very briefly, and have two main
>> complaints:
>> ...

> Please see attached v6 of the patch.

Thanks for updating that!

> I'm not sure of the convention around authorship. But since this was
> not an insignificant amount of work, would this patch be considered as
> co-authored by Przemyslaw and myself? Should I add myself to Authors
> field in the Commitfest app?

While I'm not promising to commit this, if I were doing so I would
cite both of you as authors.  So feel free to change the CF entry.

			regards, tom lane

Commits

  1. Add functions to do timestamptz arithmetic in a non-default timezone.

  2. Refactor datetime functions' timezone lookup code to reduce duplication.

  3. Fix volatility marking of timestamptz_trunc_zone.