Re: [HACKERS] Call for objections: simplify stable functions during estimation

2004-11-09 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > On Tuesday 09 November 2004 11:28, Tom Lane wrote: >> (One of the potential objections went away when >> we started enforcing that stable functions don't have side-effects.) > Since we know people will be calling volatile functions inside stable > functi

Re: [HACKERS] Call for objections: simplify stable functions during estimation

2004-11-09 Thread Robert Treat
On Tuesday 09 November 2004 11:28, Tom Lane wrote: > Awhile back, there was some discussion about pre-folding now() and > related functions when the planner is trying to estimate selectivities. > This would allow reasonable plans to be made for cases like > WHERE moddate >= current_date - 10; > wi

Re: [HACKERS] Call for objections: simplify stable functions during

2004-11-09 Thread Marc G. Fournier
On Tue, 9 Nov 2004, Tom Lane wrote: Awhile back, there was some discussion about pre-folding now() and related functions when the planner is trying to estimate selectivities. This would allow reasonable plans to be made for cases like WHERE moddate >= current_date - 10; without having to in