CALL Statement

The CALL statement invokes the given table function and returns the results.

Thanks to the FROM-first syntax and the fact that procedures in Goose are implemented as table functions, you can use FROM instead of CALL.

Examples

Invoke the 'goose_functions' table function:

CALL goose_functions();

Invoke the 'pragma_table_info' table function:

CALL pragma_table_info('pg_am');

Select only the functions where the name starts with ST_:

SELECT function_name, parameters, parameter_types, return_type
FROM goose_functions()
WHERE function_name LIKE 'ST_%';