Home Explore Blog CI



postgresql

63th chunk of `doc/src/sgml/information_schema.sgml`
86ae1e5d64754fd03b085528be1f2b8014efb027bfd73fde0000000100000fa3
 role="catalog_table_entry"><para role="column_definition">
       <structfield>numeric_scale</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>datetime_precision</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>interval_type</structfield> <type>character_data</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>interval_precision</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Always null, since this information is not applied to return data types in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>type_udt_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the database that the return data type of the function
       is defined in (always the current database).  Null for a procedure.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>type_udt_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the schema that the return data type of the function is
       defined in.  Null for a procedure.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>type_udt_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Name of the return data type of the function.  Null for a procedure.
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>scope_catalog</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Applies to a feature not available in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>scope_schema</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Applies to a feature not available in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>scope_name</structfield> <type>sql_identifier</type>
      </para>
      <para>
       Applies to a feature not available in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>maximum_cardinality</structfield> <type>cardinal_number</type>
      </para>
      <para>
       Always null, because arrays always have unlimited maximum cardinality in <productname>PostgreSQL</productname>
      </para></entry>
     </row>

     <row>
      <entry role="catalog_table_entry"><para role="column_definition">
       <structfield>dtd_identifier</structfield> <type>sql_identifier</type>
      </para>
      <para>
       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

Title: Information Schema: Routines View Columns
Summary
This section describes additional columns of the 'routines' view in PostgreSQL, including numeric scale, datetime precision, interval type, and others, with explanations of their values and applicability to functions and procedures in PostgreSQL.