Post #3900721
2026-07-09 07:34 UTC
@felixxm@fosstodon.org PostgreSQL also provides a `uuid_extract_timestamp` function so it should be possible to write a transform allowing us to do `Q(uuid__timestamp__gte=midnight)`
Replies (2)
-
@adamchainz@fosstodon.org 2026-07-09 07:39
@ngnpope@fosstodon.org @felixxm@fosstodon.org very cool
-
@felixxm@fosstodon.org 2026-07-09 07:45
@ngnpope@fosstodon.org Yes 👍️ but then we need another index 🤔 on `uuid_extract_timestamp(uuid_field)`.