Andy Fan schrieb am 28.09.2020 um 02:54: > Well, that's very interesting. Specific to my user case, > SELECT * FROM p WHERE pkey = to_date('2018-12-13', 'yyyy-mm-dd)';
Why use to_date() at all for a constant value? Can't you use a standard ANSI date literal (date '2018-12-13')? Alternatively, you could use make_date(2018,12,13) which is marked as immutable. Thomas