A note-to-self on avoiding DST issues when joining between tables.
Two gotchas that I wasted time on.
Quick tip on tweaking the output of psql
Quick tip on avoiding accidental data loss
Harder than it should be
Using ‘USING’ to cast correctly
The recommended way of debugging SQL problems