citusdata / pg_cron

Run periodic jobs in PostgreSQL
PostgreSQL License
2.78k stars 189 forks source link

An undocumented behavior with years in Cron expressions #341

Open sanchezcarlosjr opened 1 month ago

sanchezcarlosjr commented 1 month ago

The cron expression can consist of either six or five fields separated by white space, but the documentation states that it should only comprise five fields. I tested this before making the statement.

This implies that we can include years in the expression ' * 2024' and one running cron expressions. Am I wrong?

marcoslot commented 1 month ago

There's no logic to parse years in the pg_cron cron syntax.