Optimize constant MinMax expressions
Vik Fearing <vik.fearing@2ndquadrant.com>
From: Vik Fearing <vik.fearing@2ndquadrant.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2018-12-29T21:40:14Z
Lists: pgsql-hackers
Attachments
- optimize_constant_least_greatest.v01.patch (text/x-patch) patch v1
I was working on a little thing where I needed to simulate BETWEEN SYMMETRIC so naturally I used least() and greatest(). I was a little surprised to see that my expressions were not folded into straight constants and the estimates were way off as a consequence. I came up with the attached patch to fix it, but it's so ridiculously small that I fear I'm missing something. I don't think this needs any documentation and I didn't see where we have any existing tests for eval_const_expressions so I didn't create any either. Thoughts? -- Vik Fearing +33 6 46 75 15 36 http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
Commits
-
Teach eval_const_expressions to constant-fold LEAST/GREATEST expressions.
- 6f19a8c41f97 12.0 landed