Homepage Recent Changes

Recent Changes

Updates in the last 30 days

(for "2026-01-26 A simple but nice PostgreSQL trick with timestamps and nulls" only)

1 | 3 | 7 | 30 | 90 days
List all changes Include rollbacks Include minor changes
List later changes RSS RSS with pages RSS with pages and diff

2026-01-26

  • 20:17 UTC (new) (history) 2026-01-26 A simple but nice PostgreSQL trick with timestamps and nulls . . . . mbork – I had a pretty busy week, so today I only have a short PostgreSQL tip I learned recently. Assume that you have a table of users, and it has two columns containing timestamps: created_at and deleted_at. The former is non-nullable, but the latter can contain nulls (for users who were never deleted). Let’s assume that you want to select all users who existed at some point in time, say today at midnight.

More...

Filters

Comments on Recent Changes This page is read-only View other revisions Administration