|
|
|
Table valued functions make dynamic table query available by allowing calculated stored procedure results to be used in place of a table reference in the FROM clause of a SELECT statement.
Example
Consider a stored procedure that builds a list of customers given a set of parameters:
proc_get_overdue_customers_by_zip (
IN zip CHAR(5),
IN calc_by_days INTEGER
)
RESULT (last_name CHAR(20), first_name CHAR(20), balance_due MONEY, days_overdue INTEGER)
As a table valued function, this procedure can be directly referenced in your SELECT statement.
SELECT last_name, first_name, balance_due, days_overdue FROM proc_get_overdue_customers_by_zip('65203', 90);
