Paolo Melchiorre pauloxnet

🐍

https://www.paulox.net

@psf fellow · DSF director · @python / @django dev · @DjangoGirls coach · @djangonaut-space navigator · @PythonPescara founder · @pythonitalia Conference staff

cobusc / postgresql_date_function_index_howto.md

Last active July 26, 2024 09:16

Short explanation of the issues faced when trying to create a PostgreSQL index using the date() function and how to resolve it.

Update: 2023/11/30 Bruce Momjian's take on things: https://momjian.us/main/blogs/pgblog/2023.html#November_22_2023

Given a table...

CREATE TABLE foo (
  id SERIAL PRIMARY KEY,
  created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
  ...
);