Home • Explore • Blog • CI
☰



postgresql
45th chunk of `doc/src/sgml/ecpg.sgml`
babe58f070378c0ce52015c0a6a9d52095de0bf111a0d9c80000000100000fa1

       <para>
        number of rows in the result set
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-data">
      <term><literal>DATA</literal></term>
      <listitem>
       <para>
        actual data item (therefore, the data type of this field
        depends on the query)
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-datetime-interval-code">
      <term><literal>DATETIME_INTERVAL_CODE</literal> (integer)</term>
      <listitem>
       <para>
        When <literal>TYPE</literal> is <literal>9</literal>,
        <literal>DATETIME_INTERVAL_CODE</literal> will have a value of
        <literal>1</literal> for <literal>DATE</literal>,
        <literal>2</literal> for <literal>TIME</literal>,
        <literal>3</literal> for <literal>TIMESTAMP</literal>,
        <literal>4</literal> for <literal>TIME WITH TIME ZONE</literal>, or
        <literal>5</literal> for <literal>TIMESTAMP WITH TIME ZONE</literal>.
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-datetime-interval-precision">
      <term><literal>DATETIME_INTERVAL_PRECISION</literal> (integer)</term>
      <listitem>
       <para>
        not implemented
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-indicator">
      <term><literal>INDICATOR</literal> (integer)</term>
      <listitem>
       <para>
        the indicator (indicating a null value or a value truncation)
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-key-member">
      <term><literal>KEY_MEMBER</literal> (integer)</term>
      <listitem>
       <para>
        not implemented
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-length">
      <term><literal>LENGTH</literal> (integer)</term>
      <listitem>
       <para>
        length of the datum in characters
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-name">
      <term><literal>NAME</literal> (string)</term>
      <listitem>
       <para>
        name of the column
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-nullable">
      <term><literal>NULLABLE</literal> (integer)</term>
      <listitem>
       <para>
        not implemented
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-octet-length">
      <term><literal>OCTET_LENGTH</literal> (integer)</term>
      <listitem>
       <para>
        length of the character representation of the datum in bytes
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-precision">
      <term><literal>PRECISION</literal> (integer)</term>
      <listitem>
       <para>
        precision (for type <type>numeric</type>)
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-returned-length">
      <term><literal>RETURNED_LENGTH</literal> (integer)</term>
      <listitem>
       <para>
        length of the datum in characters
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-returned-octet-length">
      <term><literal>RETURNED_OCTET_LENGTH</literal> (integer)</term>
      <listitem>
       <para>
        length of the character representation of the datum in bytes
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-scale">
      <term><literal>SCALE</literal> (integer)</term>
      <listitem>
       <para>
        scale (for type <type>numeric</type>)
       </para>
      </listitem>
     </varlistentry>

     <varlistentry id="ecpg-named-descriptors-type">
      <term><literal>TYPE</literal> (integer)</term>
      <listitem>
       <para>
        numeric code
Title: Detailed Field Descriptions for Named SQL Descriptor Areas in ECPG
Summary
This section provides a detailed description of the available fields within a named SQL descriptor area in ECPG. These fields include CARDINALITY (number of rows), DATA (actual data item), DATETIME_INTERVAL_CODE (specifies date/time type), DATETIME_INTERVAL_PRECISION, INDICATOR (null value or truncation), KEY_MEMBER, LENGTH (datum length in characters), NAME (column name), NULLABLE, OCTET_LENGTH (datum length in bytes), PRECISION (numeric precision), RETURNED_LENGTH (datum length), RETURNED_OCTET_LENGTH (datum length in bytes), SCALE (numeric scale), and TYPE (numeric code).