Optimize constant MinMax expressions - Mailing list pgsql-hackers

From Vik Fearing
Subject Optimize constant MinMax expressions
Date
Msg-id c6e8504c-4c43-35fa-6c8f-3c0b80a912cc@2ndquadrant.com
Whole thread Raw
Responses Re: Optimize constant MinMax expressions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: random() (was Re: New GUC to sample log queries)
Next
From: John Naylor
Date:
Subject: Re: reducing the footprint of ScanKeyword (was Re: Large writable variables)