News for hackers. Stuff that matters.
Re:Using Redundant Conditions to Unlock Indexes in MySQL by wswope on Wednesday June 07, 2023 @04:46PM (#36233304)
Yeah, you've got the right idea. Specifically, functions that operate on TIMESTAMPTZ aren't typically marked as IMMUTABLE (because their output implicitly depends on the connection-level time zone setting), and that IMMUTABLE flag is required for functions used in indexed expressions.

https://www.postgresql.org/docs/current/xfunc-volatility.htm...

There are no comments on this comment yet.