pgsql: Add a planner support function for numeric generate_series(). - Mailing list pgsql-committers

From Dean Rasheed
Subject pgsql: Add a planner support function for numeric generate_series().
Date
Msg-id E1tI4mP-000jhj-Ey@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
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

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/97173536ed4b1c29dce0dc4119db136e142f60a2

Modified Files
--------------
src/backend/utils/adt/numeric.c              | 121 +++++++++++++++++++++++++++
src/include/catalog/catversion.h             |   2 +-
src/include/catalog/pg_proc.dat              |   9 +-
src/test/regress/expected/misc_functions.out |  65 ++++++++++++++
src/test/regress/sql/misc_functions.sql      |  38 +++++++++
5 files changed, 232 insertions(+), 3 deletions(-)


pgsql-committers by date:

Previous
From: Dean Rasheed
Date:
Subject: pgsql: Fix #include order in timestamp.c.
Next
From: Nathan Bossart
Date:
Subject: pgsql: Deprecate MD5 passwords.