Function doesn't return expected result. it should return every second TH
SELECT
rr.v
FROM _rrule.occurrences(
( '{
"dtend": "2024-11-14T19:00:00",
"rdate": null,
"rrule": {
"freq": "WEEKLY",
"wkst": "MO",
"byday": [
"TH"
],
"count": null,
"until": "2025-01-23T08:07:28",
"byhour": null,
"bymonth": null,
"byminute": null,
"bysecond": null,
"bysetpos": null,
"byweekno": null,
"interval": 2,
"byyearday": null,
"bymonthday": null
},
"exdate": [
"2024-12-26T17:30:00"
],
"exrule": null,
"dtstart": "2024-11-14T17:30:00"
}' )::jsonb :: rruleset
) rr (v)
order BY rr.v
my result
v
14/11/2024 17:30:00.000000
21/11/2024 17:30:00.000000
28/11/2024 17:30:00.000000
05/12/2024 17:30:00.000000
12/12/2024 17:30:00.000000
19/12/2024 17:30:00.000000
02/01/2025 17:30:00.000000
09/01/2025 17:30:00.000000
16/01/2025 17:30:00.000000
Function doesn't return expected result. it should return every second TH
SELECT
rr.v
FROM _rrule.occurrences(
( '{
"dtend": "2024-11-14T19:00:00",
"rdate": null,
"rrule": {
"freq": "WEEKLY",
"wkst": "MO",
"byday": [
"TH"
],
"count": null,
"until": "2025-01-23T08:07:28",
"byhour": null,
"bymonth": null,
"byminute": null,
"bysecond": null,
"bysetpos": null,
"byweekno": null,
"interval": 2,
"byyearday": null,
"bymonthday": null
},
"exdate": [
"2024-12-26T17:30:00"
],
"exrule": null,
"dtstart": "2024-11-14T17:30:00"
}' )::jsonb :: rruleset
) rr (v)
order BY rr.v
my result
v
14/11/2024 17:30:00.000000
21/11/2024 17:30:00.000000
28/11/2024 17:30:00.000000
05/12/2024 17:30:00.000000
12/12/2024 17:30:00.000000
19/12/2024 17:30:00.000000
02/01/2025 17:30:00.000000
09/01/2025 17:30:00.000000
16/01/2025 17:30:00.000000