call_function

Includes functions for interacting with common meta data fields,
writing insert statements, calling functions, and more for 'T-SQL' and 'Postgresql'.

Timothy Conwell

sqlHelpers

Collection of 'SQL' Utilities for 'T-SQL' and 'Postgresql'

call_function function

<dl><dt>con</dt>
<dd>A database connection.</dd>
<dt>schema</dt>
<dd>A string, the schema to query.</dd>
<dt>function_name</dt>
<dd>A string, the function/procedure to query.</dd>
<dt>args</dt>
<dd>A named list or vector, names are the parameter names and values are the parameter values.</dd>
<dt>dialect</dt>
<dd>A string, "T-SQL" or "Postgresql".,</dd>
<dt>cast</dt>
<dd>TRUE/FALSE, if TRUE, will add SQL to cast the parameters to the specified type.</dd></dl>

Arguments

Call a SQL function/procedure. — call_function

<dl>

<dt>con</dt>
<dd>A database connection.</dd>


<dt>schema</dt>
<dd>A string, the schema to query.</dd>


<dt>function_name</dt>
<dd>A string, the function/procedure to query.</dd>


<dt>args</dt>
<dd>A named list or vector, names are the parameter names and values are the parameter values.</dd>


<dt>dialect</dt>
<dd>A string, "T-SQL" or "Postgresql".,</dd>


<dt>cast</dt>
<dd>TRUE/FALSE, if TRUE, will add SQL to cast the parameters to the specified type.</dd>

</dl>

call_function: Call a SQL function/procedure.

Description

Usage

Value

Arguments

Examples