| Server IP : 103.119.228.120 / Your IP : 3.145.92.98 Web Server : Apache System : Linux v8.techscape8.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : nobody ( 99) PHP Version : 5.6.40 Disable Function : shell_exec,symlink,system,exec,proc_get_status,proc_nice,proc_terminate,define_syslog_variables,syslog,openlog,closelog,escapeshellcmd,passthru,ocinum cols,ini_alter,leak,listen,chgrp,apache_note,apache_setenv,debugger_on,debugger_off,ftp_exec,dl,dll,myshellexec,proc_open,socket_bind,proc_close,escapeshellarg,parse_ini_filepopen,fpassthru,exec,passthru,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,popen,show_source,proc_nice,proc_terminate,proc_get_status,proc_close,pfsockopen,leak,apache_child_terminate,posix_kill,posix_mkfifo,posix_setpgid,posix_setsid,posix_setuid,dl,symlink,shell_exec,system,dl,passthru,escapeshellarg,escapeshellcmd,myshellexec,c99_buff_prepare,c99_sess_put,fpassthru,getdisfunc,fx29exec,fx29exec2,is_windows,disp_freespace,fx29sh_getupdate,fx29_buff_prepare,fx29_sess_put,fx29shexit,fx29fsearch,fx29ftpbrutecheck,fx29sh_tools,fx29sh_about,milw0rm,imagez,sh_name,myshellexec,checkproxyhost,dosyayicek,c99_buff_prepare,c99_sess_put,c99getsource,c99sh_getupdate,c99fsearch,c99shexit,view_perms,posix_getpwuid,posix_getgrgid,posix_kill,parse_perms,parsesort,view_perms_color,set_encoder_input,ls_setcheckboxall,ls_reverse_all,rsg_read,rsg_glob,selfURL,dispsecinfo,unix2DosTime,addFile,system,get_users,view_size,DirFiles,DirFilesWide,DirPrintHTMLHeaders,GetFilesTotal,GetTitles,GetTimeTotal,GetMatchesCount,GetFileMatchesCount,GetResultFiles,fs_copy_dir,fs_copy_obj,fs_move_dir,fs_move_obj,fs_rmdir,SearchText,getmicrotime MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/postgresql-9.2.24/html/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>routines</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.2.24 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="The Information Schema"
HREF="information-schema.html"><LINK
REL="PREVIOUS"
TITLE="routine_privileges"
HREF="infoschema-routine-privileges.html"><LINK
REL="NEXT"
TITLE="schemata"
HREF="infoschema-schemata.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2017-11-06T22:43:11"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.2.24 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="routine_privileges"
HREF="infoschema-routine-privileges.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="information-schema.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Chapter 34. The Information Schema</TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="schemata"
HREF="infoschema-schemata.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="INFOSCHEMA-ROUTINES"
>34.40. <TT
CLASS="LITERAL"
>routines</TT
></A
></H1
><P
> The view <TT
CLASS="LITERAL"
>routines</TT
> contains all functions in the
current database. Only those functions are shown that the current
user has access to (by way of being the owner or having some
privilege).
</P
><DIV
CLASS="TABLE"
><A
NAME="AEN49838"
></A
><P
><B
>Table 34-38. <TT
CLASS="LITERAL"
>routines</TT
> Columns</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><COL><THEAD
><TR
><TH
>Name</TH
><TH
>Data Type</TH
><TH
>Description</TH
></TR
></THEAD
><TBODY
><TR
><TD
><TT
CLASS="LITERAL"
>specific_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Name of the database containing the function (always the current database)</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>specific_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Name of the schema containing the function</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>specific_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
> The <SPAN
CLASS="QUOTE"
>"specific name"</SPAN
> of the function. This is a
name that uniquely identifies the function in the schema, even
if the real name of the function is overloaded. The format of
the specific name is not defined, it should only be used to
compare it to other instances of specific routine names.
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>routine_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Name of the database containing the function (always the current database)</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>routine_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Name of the schema containing the function</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>routine_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Name of the function (might be duplicated in case of overloading)</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>routine_type</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
> Always <TT
CLASS="LITERAL"
>FUNCTION</TT
> (In the future there might
be other types of routines.)
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>module_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>module_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>module_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>udt_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>udt_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>udt_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>data_type</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
> Return data type of the function, if it is a built-in type, or
<TT
CLASS="LITERAL"
>ARRAY</TT
> if it is some array (in that case, see
the view <TT
CLASS="LITERAL"
>element_types</TT
>), else
<TT
CLASS="LITERAL"
>USER-DEFINED</TT
> (in that case, the type is
identified in <TT
CLASS="LITERAL"
>type_udt_name</TT
> and associated
columns).
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>character_maximum_length</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>character_octet_length</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>character_set_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>character_set_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>character_set_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>collation_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>collation_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>collation_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>numeric_precision</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>numeric_precision_radix</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>numeric_scale</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>datetime_precision</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>interval_type</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>interval_precision</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Always null, since this information is not applied to return data types in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>type_udt_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
> Name of the database that the return data type of the function
is defined in (always the current database)
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>type_udt_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
> Name of the schema that the return data type of the function is
defined in
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>type_udt_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
> Name of the return data type of the function
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>scope_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>scope_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>scope_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>maximum_cardinality</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Always null, because arrays always have unlimited maximum cardinality in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>dtd_identifier</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
> An identifier of the data type descriptor of the return data
type of this function, unique among the data type descriptors
pertaining to the function. This is mainly useful for joining
with other instances of such identifiers. (The specific format
of the identifier is not defined and not guaranteed to remain
the same in future versions.)
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>routine_body</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
> If the function is an SQL function, then
<TT
CLASS="LITERAL"
>SQL</TT
>, else <TT
CLASS="LITERAL"
>EXTERNAL</TT
>.
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>routine_definition</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
> The source text of the function (null if the function is not
owned by a currently enabled role). (According to the SQL
standard, this column is only applicable if
<TT
CLASS="LITERAL"
>routine_body</TT
> is <TT
CLASS="LITERAL"
>SQL</TT
>, but
in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> it will contain
whatever source text was specified when the function was
created.)
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>external_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
> If this function is a C function, then the external name (link
symbol) of the function; else null. (This works out to be the
same value that is shown in
<TT
CLASS="LITERAL"
>routine_definition</TT
>.)
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>external_language</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
>The language the function is written in</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>parameter_style</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
> Always <TT
CLASS="LITERAL"
>GENERAL</TT
> (The SQL standard defines
other parameter styles, which are not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
>.)
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>is_deterministic</TT
></TD
><TD
><TT
CLASS="TYPE"
>yes_or_no</TT
></TD
><TD
> If the function is declared immutable (called deterministic in
the SQL standard), then <TT
CLASS="LITERAL"
>YES</TT
>, else
<TT
CLASS="LITERAL"
>NO</TT
>. (You cannot query the other volatility
levels available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
> through the information schema.)
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>sql_data_access</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
> Always <TT
CLASS="LITERAL"
>MODIFIES</TT
>, meaning that the function
possibly modifies SQL data. This information is not useful for
<SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
>.
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>is_null_call</TT
></TD
><TD
><TT
CLASS="TYPE"
>yes_or_no</TT
></TD
><TD
> If the function automatically returns null if any of its
arguments are null, then <TT
CLASS="LITERAL"
>YES</TT
>, else
<TT
CLASS="LITERAL"
>NO</TT
>.
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>sql_path</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>schema_level_routine</TT
></TD
><TD
><TT
CLASS="TYPE"
>yes_or_no</TT
></TD
><TD
> Always <TT
CLASS="LITERAL"
>YES</TT
> (The opposite would be a method
of a user-defined type, which is a feature not available in
<SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
>.)
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>max_dynamic_result_sets</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>is_user_defined_cast</TT
></TD
><TD
><TT
CLASS="TYPE"
>yes_or_no</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>is_implicitly_invocable</TT
></TD
><TD
><TT
CLASS="TYPE"
>yes_or_no</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>security_type</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
> If the function runs with the privileges of the current user,
then <TT
CLASS="LITERAL"
>INVOKER</TT
>, if the function runs with the
privileges of the user who defined it, then
<TT
CLASS="LITERAL"
>DEFINER</TT
>.
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>to_sql_specific_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>to_sql_specific_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>to_sql_specific_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>as_locator</TT
></TD
><TD
><TT
CLASS="TYPE"
>yes_or_no</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>created</TT
></TD
><TD
><TT
CLASS="TYPE"
>time_stamp</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>last_altered</TT
></TD
><TD
><TT
CLASS="TYPE"
>time_stamp</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>new_savepoint_level</TT
></TD
><TD
><TT
CLASS="TYPE"
>yes_or_no</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>is_udt_dependent</TT
></TD
><TD
><TT
CLASS="TYPE"
>yes_or_no</TT
></TD
><TD
> Currently always <TT
CLASS="LITERAL"
>NO</TT
>. The alternative
<TT
CLASS="LITERAL"
>YES</TT
> applies to a feature not available in
<SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
>.
</TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_from_data_type</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_as_locator</TT
></TD
><TD
><TT
CLASS="TYPE"
>yes_or_no</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_char_max_length</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_char_octet_length</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_char_set_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_char_set_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_char_set_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_collation_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_collation_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_collation_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_numeric_precision</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_numeric_precision_radix</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_numeric_scale</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_datetime_precision</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_interval_type</TT
></TD
><TD
><TT
CLASS="TYPE"
>character_data</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_interval_precision</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_type_udt_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_type_udt_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_type_udt_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_scope_catalog</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_scope_schema</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_scope_name</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_maximum_cardinality</TT
></TD
><TD
><TT
CLASS="TYPE"
>cardinal_number</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>result_cast_dtd_identifier</TT
></TD
><TD
><TT
CLASS="TYPE"
>sql_identifier</TT
></TD
><TD
>Applies to a feature not available in <SPAN
CLASS="PRODUCTNAME"
>PostgreSQL</SPAN
></TD
></TR
></TBODY
></TABLE
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="infoschema-routine-privileges.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="infoschema-schemata.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><TT
CLASS="LITERAL"
>routine_privileges</TT
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="information-schema.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><TT
CLASS="LITERAL"
>schemata</TT
></TD
></TR
></TABLE
></DIV
></BODY
></HTML
>