/changingroom
Keeping Postgres queries honest
The query that lied
Replace this paragraph with your actual writing. Tell the story of the bug, the wrong assumption, and where things went sideways.
What was actually happening
Walk through the root cause here. Use inline code for column names,
function names, or short snippets.
-- example query block
SELECT *
FROM orders
WHERE status = 'shipped'
AND created_at > now() - interval '7 days';The habits that catch it early
Finish with the takeaway — the practice, the tool, or the mental model you now apply to prevent this class of bug from shipping.
- Habit one
- Habit two
- Habit three