Horton

Add a planner support function for numeric generate_series().

Dean Rasheed <dean.a.rasheed@gmail.com>

View on postgr.es
Commit: 97173536ed4b1c29dce0dc4119db136e142f60a2
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
Date: 2024-12-02T11:37:57Z
Releases: 18.0 
Add a planner support function for numeric generate_series().

This allows the planner to estimate the number of rows returned by
generate_series(numeric, numeric[, numeric]), when the input values
can be estimated at plan time.

Song Jinzhou, reviewed by Dean Rasheed and David Rowley.

Discussion: https://postgr.es/m/tencent_F43E7F4DD50EF5986D1051DE8DE547910206%40qq.com
Discussion: https://postgr.es/m/tencent_1F6D5B9A1545E02FD7D0EE508DFD056DE50A%40qq.com

Files

PathChange+/−
src/backend/utils/adt/numeric.c modified +121 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +7 −2
src/test/regress/expected/misc_functions.out modified +65 −0
src/test/regress/sql/misc_functions.sql modified +38 −0

Discussion