61: I'm Not Telling You My Birthday

"Send me an email every year for my birthday" is an easy thing for a human to understand but it can be deceptively tricky to do with computers. Also tricky for (some) computers: SELECT * FROM <empty_table>. Wait... what?

• DATE_PART or EXTRACT
• Triggers
• Using EXPLAIN
• Using ANALYZE
• VACUUM
• Derek's (mostly useless) Approximately Gem

Episode source