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
-
-
The JSONB column contains a lot of information and also something like this: {"date":"2020-01-01", "time":"12:30:00"}
-
ooh, nasty. Is it in some known timezone?
- 3 more replies
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.