Soft deletion with PostgreSQL: but with logic on the database!—Martian Chronicles, Evil Martians’ team blog

Rubyists might take special pleasure here, but every SQL and PostgreSQL dev can learn this unorthodox approach: putting soft delete logic on the database side.