_v_function
The _v_function view lists all of the functions (user-defined as well as
built-in) that are available in the Netezza database.
All of the functions that were created with nzLua have a dependency for the
This query can be used to display all of the nzLua user-defined functions and table
functions that are installed in the database. The version of nzLua used for each UDX can be
determined based on the name of the LIBNZLUA library shown in the dependencies column.
LIBNZLUA library.
| Column | Description |
|---|---|
| FUNCTION | The name of the function. |
| DESCRIPTION | The description can be set using the COMMENT command or by defining the
getComment() method. |
| ARGUMENTS | The argument types accepted by the function. |
| DETERMINISTIC | A true/false indicator of whether the function is deterministic. |
| VARARGS | A true/false indicator of whether the function is a varargs function. |
| DEPENDENCIES | The libraries that a function depends on. All nzLua UDXs have a dependency on the
LIBNZLUA library. Dependencies for other libraries might also exist based on usage
of the require function. |
| RETURNS | The result type(s) of the function. |
| LOCATION | For table functions, indicates if the function runs in parallel or if only a single copy of the UDTF runs on the Netezza host system. |
Example:
select function, dependencies, arguments, returns from _v_function
where dependencies like '%NZLUA%'
order by 1;