I've found a very interesting and short explanation of the issues faced when trying to create a PostgreSQL index using the date() function and how to resolve it. 
#postgresql #function #indexes #immutable #timezone #database
CC @PostgreSQLhttps://gist.github.com/cobusc/5875282
-
-
Unfortunately I haven't created the table and I can't remove the JSONB column , but I can add a generated column or an indexe. The timezone is always CET.
-
Sounds like a function will be your best bet.
- 1 more reply
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.