Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jm19K-0004x2-OM for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jun 2020 20:28:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jm19J-0001Js-LI for pgsql-hackers@arkaria.postgresql.org; Thu, 18 Jun 2020 20:28:37 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jm19J-0001Jh-EM for pgsql-hackers@lists.postgresql.org; Thu, 18 Jun 2020 20:28:37 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jm19H-00032B-HL for pgsql-hackers@lists.postgresql.org; Thu, 18 Jun 2020 20:28:36 +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 05IKSX321594653; Thu, 18 Jun 2020 16:28:34 -0400 From: Tom Lane To: Robert Haas cc: PostgreSQL Hackers Subject: Re: More tzdb fun: POSIXRULES is being deprecated upstream In-reply-to: References: <1390.1562258309@sss.pgh.pa.us> <1452646.1592417333@sss.pgh.pa.us> <1525464.1592454364@sss.pgh.pa.us> <1554171.1592499941@sss.pgh.pa.us> Comments: In-reply-to Robert Haas message dated "Thu, 18 Jun 2020 14:15:41 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1594651.1592512113.1@sss.pgh.pa.us> Date: Thu, 18 Jun 2020 16:28:33 -0400 Message-ID: <1594652.1592512113@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Robert Haas writes: > You could consider something along the lines of: > This form specifies a transition that always happens during the same > month and on the same day of the week. m identifies the month, from 1 > to 12. n specifies the n'th occurrence of the day number identified by > d. n is a value between 1 and 4, or 5 meaning the last occurrence of > that weekday in the month (which could be the fourth or the fifth). d > is a value between 0 and 6, with 0 indicating Sunday. Adopted with some minor tweaks. Thanks for the suggestion! regards, tom lane