Add COST and ROWS options to CREATE/ALTER FUNCTION, plus underlying pg_proc

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 5a7471c307533a1b56260b3b074dfdd20e1be5ae
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2007-01-22T01:35:23Z
Releases: 8.3.0
Add COST and ROWS options to CREATE/ALTER FUNCTION, plus underlying pg_proc
columns procost and prorows, to allow simple user adjustment of the estimated
cost of a function call, as well as control of the estimated number of rows
returned by a set-returning function.  We might eventually wish to extend this
to allow function-specific estimation routines, but there seems to be
consensus that we should try a simple constant estimate first.  In particular
this provides a relatively simple way to control the order in which different
WHERE clauses are applied in a plan node, which is a Good Thing in view of the
fact that the recent EquivalenceClass planner rewrite made that much less
predictable than before.

Files