Perform this hours of operation query in PostgreSQL
Table layout Re-design the table to store opening hours (hours of operation) as a set of tsrange (range of timestamp without time zone) values. Requires Postgres 9.2 or later. Pick a random week to stage your opening hours. I like the week: 1996-01-01 (Monday) to 1996-01-07 (Sunday) That’s the most recent leap year where Jan … Read more