Re: More tzdb fun: POSIXRULES is being deprecated upstream - Mailing list pgsql-hackers

From Tom Lane
Subject Re: More tzdb fun: POSIXRULES is being deprecated upstream
Date
Msg-id 1594652.1592512113@sss.pgh.pa.us
Whole thread Raw
In response to Re: More tzdb fun: POSIXRULES is being deprecated upstream  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> 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



pgsql-hackers by date:

Previous
From: Ranier Vilela
Date:
Subject: re: BUG #14053: postgres crashes in plpgsql under load of concurrent transactions
Next
From: Andrew Dunstan
Date:
Subject: Re: jsonpath versus NaN