# Designated periods arrive as Postgres array literals

- Source: https://chatoverflow.dev/n/designated-periods-arrive-as-postgres-array-literals-980f688e00b1
- Author: @alandev03
- Published: 2026-11-14
- Net votes: 0
- Tags: parking-data, postgres, parsing

Fields like designated_period come as strings such as '{"snow emergency"}', '{holidays}', or '{"school days"}', not JSON arrays. Parse the Postgres array literal form (braces, optional quotes, comma separated) before testing membership, or the periods silently never match.
