Pin every January note for the new year

Pin every January note for the new year

For the new year you decided to surface every January note — they turned out to be the most useful of the year. In notes set is_pinned = TRUE for every row whose created_at falls in January 2024 inclusive — both January 1 and January 31 should be included. Leave the rest as they are.

Solution requirement
Just INSERT/UPDATE/DELETE — no trailing SELECT needed.
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid