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
-
-
Thanks for your clarification. In my case I don't have a timestamp column, but a JSONB containing a date and a time on which I try to build an index or a generated column. I was trying to figure out if I could avoid writing a function as explained here:https://stackoverflow.com/a/29761984/755343 …
-
What format are your date and time values in inside the jsonb object?
- 5 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.