reset.sgml
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:3k
源码类别:

数据库系统

开发平台:

Unix_Linux

  1. <refentry id="SQL-RESET">
  2.  <refmeta>
  3.   <refentrytitle>
  4.    RESET
  5.   </refentrytitle>
  6.   <refmiscinfo>SQL - Language Statements</refmiscinfo>
  7.  </refmeta>
  8.  <refnamediv>
  9.   <refname>
  10.    RESET
  11.   </refname>
  12.   <refpurpose>
  13.    Restores run-time parameters for session to default values
  14.   </refpurpose>
  15.  </refnamediv>
  16.  <refsynopsisdiv>
  17.   <refsynopsisdivinfo>
  18.    <date>1998-09-24</date>
  19.   </refsynopsisdivinfo>
  20.   <synopsis>
  21. RESET <replaceable class="PARAMETER">variable</replaceable>
  22.   </synopsis>
  23.   <refsect2 id="R2-SQL-RESET-1">
  24.    <refsect2info>
  25.     <date>1998-09-24</date>
  26.    </refsect2info>
  27.    <title>
  28.     Inputs
  29.    </title>
  30.    <para>
  31.     <variablelist>
  32.      <varlistentry>
  33.       <term><replaceable class="PARAMETER">variable</replaceable></term>
  34.       <listitem>
  35.        <para>
  36. Refer to the SET statement for more information on available
  37. variables.
  38.        </para>
  39.       </listitem>
  40.      </varlistentry>
  41.     </variablelist>
  42.    </para>
  43.   </refsect2>
  44.   <refsect2 id="R2-SQL-RESET-2">
  45.    <refsect2info>
  46.     <date>1998-09-24</date>
  47.    </refsect2info>
  48.    <title>
  49.     Outputs
  50.    </title>
  51.    <para>
  52.     <variablelist>
  53.      <varlistentry>
  54.       <term><computeroutput>
  55. RESET VARIABLE
  56.        </computeroutput></term>
  57.       <listitem>
  58.        <para>
  59. Message returned if 
  60. <replaceable class="PARAMETER">variable</replaceable> is successfully reset
  61. to its default value..
  62.        </para>
  63.       </listitem>
  64.      </varlistentry>
  65.     </variablelist>
  66.    </para>
  67.   </refsect2>
  68.  </refsynopsisdiv>
  69.   
  70.  <refsect1 id="R1-SQL-RESET-1">
  71.   <refsect1info>
  72.    <date>1998-09-24</date>
  73.   </refsect1info>
  74.   <title>
  75.    Description
  76.   </title>
  77.   <para>
  78.    <command>RESET</command> restores variables to the
  79.    default values.
  80.    Refer to the <command>SET</command> command for details on
  81.    allowed values and defaults.
  82.    <command>RESET</command> is an alternate form for
  83.    <command>SET <replaceable class="parameter">variable</replaceable> = DEFAULT</command>
  84.   </para>
  85.   <refsect2 id="R2-SQL-RESET-3">
  86.    <refsect2info>
  87.     <date>1998-09-24</date>
  88.    </refsect2info>
  89.    <title>
  90.     Notes
  91.    </title>
  92.    <para>
  93.     The RESET statement is a <productname>Postgres</productname>
  94.     language extension.
  95.    </para>
  96.    <para>
  97.     Refer to SET/SHOW statements to set/show variable values.
  98.    </para>
  99.   </refsect2>
  100.  </refsect1>
  101.   
  102.  <refsect1 id="R1-SQL-RESET-2">
  103.   <title>
  104.    Usage
  105.   </title>
  106.   <para>
  107.    Set DateStyle to its default value:
  108.    <programlisting>
  109. RESET DateStyle;
  110.    </programlisting>
  111.   </para>
  112.   <para>
  113.    Set Geqo to its default value:
  114.    <programlisting>   
  115. RESET GEQO;
  116.    </programlisting>
  117.   </para>
  118.  </refsect1>
  119.  <refsect1 id="R1-SQL-RESET-3">
  120.   <title>
  121.    Compatibility
  122.   </title>
  123.   <refsect2 id="R2-SQL-RESET-4">
  124.    <refsect2info>
  125.     <date>1998-09-24</date>
  126.    </refsect2info>
  127.    <title>
  128.     SQL92
  129.    </title>
  130.    <para>
  131.     There is no <command>RESET</command> in <acronym>SQL92</acronym>.
  132.    </para>
  133.   </refsect2>
  134.  </refsect1>
  135. </refentry>
  136. <!-- Keep this comment at the end of the file
  137. Local variables:
  138. mode: sgml
  139. sgml-omittag:nil
  140. sgml-shorttag:t
  141. sgml-minimize-attributes:nil
  142. sgml-always-quote-attributes:t
  143. sgml-indent-step:1
  144. sgml-indent-data:t
  145. sgml-parent-document:nil
  146. sgml-default-dtd-file:"../reference.ced"
  147. sgml-exposed-tags:nil
  148. sgml-local-catalogs:"/usr/lib/sgml/catalog"
  149. sgml-local-ecat-files:nil
  150. End:
  151. -->