diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1999-07-06 17:16:42 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1999-07-06 17:16:42 +0000 |
| commit | a4ac2f458e8cb76177254f4bd7bbd885991379af (patch) | |
| tree | 278de40d122f67db3a6694319b0d3b6880eba752 /doc/src/sgml/ref/insert.sgml | |
| parent | 192a66e3dad33ff8aa446c4c053f0b01498549f5 (diff) | |
Fix markup for docbook2man man page generation.
No big deal; fixed lots of other markup at the same time.
Bigest change: make sure there is no whitespace
in front of <term> contents.
This will probably help the other output types too.
Diffstat (limited to 'doc/src/sgml/ref/insert.sgml')
| -rw-r--r-- | doc/src/sgml/ref/insert.sgml | 458 |
1 files changed, 228 insertions, 230 deletions
diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index b5e2c0241ea..2860f89e1e7 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -1,237 +1,235 @@ -<REFENTRY ID="SQL-INSERT"> -<REFMETA> -<REFENTRYTITLE> -INSERT -</REFENTRYTITLE> -<REFMISCINFO>SQL - Language Statements</REFMISCINFO> -</REFMETA> -<REFNAMEDIV> -<REFNAME> -INSERT -</REFNAME> -<REFPURPOSE> -Inserts new rows into a table -</REFPURPOSE> +<refentry id="SQL-INSERT"> + <refmeta> + <refentrytitle> + INSERT + </refentrytitle> + <refmiscinfo>SQL - Language Statements</refmiscinfo> + </refmeta> + <refnamediv> + <refname> + INSERT + </refname> + <refpurpose> + Inserts new rows into a table + </refpurpose> </refnamediv> - <REFSYNOPSISDIV> - <REFSYNOPSISDIVINFO> - <DATE>1998-09-23</DATE> - </REFSYNOPSISDIVINFO> - <SYNOPSIS> - INSERT INTO <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> [ ( <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> [, ...] ) ] - { VALUES ( <REPLACEABLE CLASS="PARAMETER">expression</REPLACEABLE> [, ...] ) | SELECT <REPLACEABLE CLASS="PARAMETER">query</REPLACEABLE> } - </SYNOPSIS> + <refsynopsisdiv> + <refsynopsisdivinfo> + <date>1998-09-23</date> + </refsynopsisdivinfo> + <synopsis> +INSERT INTO <replaceable class="PARAMETER">table</replaceable> [ ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) ] + { VALUES ( <replaceable class="PARAMETER">expression</replaceable> [, ...] ) | SELECT <replaceable class="PARAMETER">query</replaceable> } + </synopsis> - <REFSECT2 ID="R2-SQL-INSERT-1"> - <REFSECT2INFO> - <DATE>1998-09-23</DATE> - </REFSECT2INFO> - <TITLE> + <refsect2 id="R2-SQL-INSERT-1"> + <refsect2info> + <date>1998-09-23</date> + </refsect2info> + <title> Inputs - </TITLE> - <PARA> - </PARA> - <VARIABLELIST> - <VARLISTENTRY> - <TERM> - <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE> - </TERM> - <LISTITEM> - <PARA> - The name of an existing table. - </para> - </listitem> - </varlistentry> - <VARLISTENTRY> - <TERM> - <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE> - </TERM> - <LISTITEM> - <PARA> - The name of a column in <REPLACEABLE CLASS="PARAMETER">table</REPLACEABLE>. - </para> - </listitem> - </varlistentry> - - <VARLISTENTRY> - <TERM> - <REPLACEABLE CLASS="PARAMETER">expression</REPLACEABLE> - </TERM> - <LISTITEM> - <PARA> - A valid expression or value to assign to <REPLACEABLE CLASS="PARAMETER">column</REPLACEABLE>. - </para> - </listitem> - </varlistentry> - - <VARLISTENTRY> - <TERM> - <REPLACEABLE CLASS="PARAMETER">query</REPLACEABLE> - </TERM> - <LISTITEM> - <PARA> - A valid query. Refer to the SELECT statement for a further description - of valid arguments. - </para> - </listitem> - </varlistentry> - - </VARIABLELIST> - - </REFSECT2> - - <REFSECT2 ID="R2-SQL-INSERT-2"> - <REFSECT2INFO> - <DATE>1998-09-23</DATE> - </REFSECT2INFO> - <TITLE> - Outputs - </TITLE> - <PARA> - - <VARIABLELIST> - <VARLISTENTRY> - <TERM> - <ReturnValue>INSERT <replaceable>oid</replaceable></ReturnValue> 1 - </TERM> - <LISTITEM> - <PARA> - Message returned if only one row was inserted. - <ReturnValue><replaceable>oid</replaceable></ReturnValue> - is the numeric <acronym>OID</acronym> of the inserted row. - </para> - </listitem> - </varlistentry> - <VARLISTENTRY> - <TERM> - <ReturnValue>INSERT 0 <replaceable>#</replaceable></ReturnValue> - </TERM> - <LISTITEM> - <PARA> - Message returned if more than one rows were inserted. - <ReturnValue><replaceable>#</replaceable></ReturnValue> - is the number of rows inserted. - </para> - </listitem> - </varlistentry> - </VARIABLELIST> - </para> - </REFSECT2> - </REFSYNOPSISDIV> + </title> + <para> + + <variablelist> + <varlistentry> + <term><replaceable class="PARAMETER">table</replaceable></term> + <listitem> + <para> + The name of an existing table. + </para> + </listitem> + </varlistentry> + <varlistentry> + <term><replaceable class="PARAMETER">column</replaceable></term> + <listitem> + <para> + The name of a column in <replaceable class="PARAMETER">table</replaceable>. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="PARAMETER">expression</replaceable></term> + <listitem> + <para> + A valid expression or value to assign to <replaceable + class="PARAMETER">column</replaceable>. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><replaceable class="PARAMETER">query</replaceable></term> + <listitem> + <para> + A valid query. Refer to the SELECT statement for a further description + of valid arguments. + </para> + </listitem> + </varlistentry> + </variablelist> + </para> + </refsect2> - <REFSECT1 ID="R1-SQL-INSERT-1"> - <REFSECT1INFO> - <DATE>1998-09-02</DATE> - </REFSECT1INFO> - <TITLE> - Description - </TITLE> - <PARA> - INSERT allows one to insert new rows into a table. One can insert - a single row at time or several rows as a result of a query. - The columns in the target list may be listed in any order. - In every column not present in the target list will be inserted - the default value, if column has not a declared default value - it will be assumed as NULL. If the expression for each column - is not of the correct data type, automatic type coercion will be - attempted. - </para> - <para> - You must have insert privilege to a table in order to append - to it, as well as select privilege on any table specified - in a WHERE clause. - </para> - </refsect1> - - <REFSECT1 ID="R1-SQL-INSERT-2"> - <TITLE> - Usage - </TITLE> - <PARA> - <ProgramListing> - --Insert a single row into table films; - --(in the second example the column date_prod is omitted - --therefore will be stored in it a default value of NULL): - -- - INSERT INTO films VALUES - ('UA502','Bananas',105,'1971-07-13','Comedy',INTERVAL '82 minute'); - - INSERT INTO films (code, title, did, date_prod, kind) - VALUES ('T_601', 'Yojimbo', 106, DATE '1961-06-16', 'Drama'); - </ProgramListing> - - <ProgramListing> - --Insert a single row into table distributors, note that - --only column "name" is specified, to the non specified - --column "did" will be assigned its default value: - -- - INSERT INTO distributors (name) VALUES ('British Lion'); - </ProgramListing> - - <ProgramListing> - --Insert several rows into table films from table tmp: - -- - INSERT INTO films - SELECT * FROM tmp; - </ProgramListing> - - <ProgramListing> - --Insert into arrays: - --Create an empty 3x3 gameboard for noughts-and-crosses - --(all of these queries create the same board attribute) - --(Refer to the <citetitle>PostgreSQL User's Guide</citetitle> for further - --information about arrays). + <refsect2 id="R2-SQL-INSERT-2"> + <refsect2info> + <date>1998-09-23</date> + </refsect2info> + <title> + Outputs + </title> + <para> + + <variablelist> + <varlistentry> + <term><computeroutput> +INSERT <replaceable>oid</replaceable> 1 + </computeroutput></term> + <listitem> + <para> + Message returned if only one row was inserted. + <returnvalue><replaceable>oid</replaceable></returnvalue> + is the numeric <acronym>OID</acronym> of the inserted row. + </para> + </listitem> + </varlistentry> + <varlistentry> + <term><computeroutput> +INSERT 0 <replaceable>#</replaceable> + </computeroutput></term> + <listitem> + <para> + Message returned if more than one rows were inserted. + <returnvalue><replaceable>#</replaceable></returnvalue> + is the number of rows inserted. + </para> + </listitem> + </varlistentry> + </variablelist> + </para> + </refsect2> + </refsynopsisdiv> + + <refsect1 id="R1-SQL-INSERT-1"> + <refsect1info> + <date>1998-09-02</date> + </refsect1info> + <title> + Description + </title> + <para> + <command>INSERT</command> allows one to insert new rows into a table. One can insert + a single row at time or several rows as a result of a query. + The columns in the target list may be listed in any order. + In every column not present in the target list will be inserted + the default value, if column has not a declared default value + it will be assumed as NULL. If the expression for each column + is not of the correct data type, automatic type coercion will be + attempted. + </para> + <para> + You must have insert privilege to a table in order to append + to it, as well as select privilege on any table specified + in a WHERE clause. + </para> + </refsect1> + + <refsect1 id="R1-SQL-INSERT-2"> + <title> + Usage + </title> + <para> + Insert a single row into table <literal>films</literal>: + + <programlisting> +INSERT INTO films VALUES + ('UA502','Bananas',105,'1971-07-13','Comedy',INTERVAL '82 minute'); + </programlisting> + </para> + + <para> + In this second example the column <literal>date_prod</literal> is + omitted and therefore it will have the default value of NULL: + + <programlisting> +INSERT INTO films (code, title, did, date_prod, kind) + VALUES ('T_601', 'Yojimbo', 106, DATE '1961-06-16', 'Drama'); + </programlisting> + </para> + + <para> + Insert a single row into table distributors; note that + only column <literal>name</literal> is specified, so the omitted + column <literal>did</literal> will be assigned its default value: + + <programlisting> +INSERT INTO distributors (name) VALUES ('British Lion'); + </programlisting> + </para> + + <para> + Insert several rows into table films from table <literal>tmp</literal>: + + <programlisting> +INSERT INTO films SELECT * FROM tmp; + </programlisting> + </para> + + <para> + Insert into arrays (refer to <citetitle>The PostgreSQL User's Guide</citetitle> for further + information about arrays): - INSERT INTO tictactoe (game, board[1:3][1:3]) - VALUES (1,'{{"","",""},{},{"",""}}'); - INSERT INTO tictactoe (game, board[3][3]) - VALUES (2,'{}'); - INSERT INTO tictactoe (game, board) - VALUES (3,'{{,,},{,,},{,,}}'); - </ProgramListing> - </para> - </REFSECT1> - - <REFSECT1 ID="R1-SQL-INSERT-3"> - <TITLE> - Compatibility - </TITLE> - <PARA> - </PARA> + <programlisting> +-- Create an empty 3x3 gameboard for noughts-and-crosses +-- (all of these queries create the same board attribute) +INSERT INTO tictactoe (game, board[1:3][1:3]) + VALUES (1,'{{"","",""},{},{"",""}}'); +INSERT INTO tictactoe (game, board[3][3]) + VALUES (2,'{}'); +INSERT INTO tictactoe (game, board) + VALUES (3,'{{,,},{,,},{,,}}'); + </programlisting> + </para> + </refsect1> + + <refsect1 id="R1-SQL-INSERT-3"> + <title> + Compatibility + </title> + <para> + </para> - <REFSECT2 ID="R2-SQL-INSERT-4"> - <REFSECT2INFO> - <DATE>1998-09-23</DATE> - </REFSECT2INFO> - <TITLE> - SQL92 - </TITLE> - <PARA> - The INSERT statement is fully compatible with <acronym>SQL92</acronym>. - Possible limitations in features of the - <REPLACEABLE CLASS="PARAMETER">query</REPLACEABLE> - clause are documented for the SELECT statement. - </para> - </refsect2> - </refsect1> -</REFENTRY> - -<!-- -<REPLACEABLE CLASS="PARAMETER"> -</REPLACEABLE> -<ReturnValue></ReturnValue> -<PARA> -</PARA> -<VARIABLELIST> -<VARLISTENTRY> -<TERM>• -</TERM> -<LISTITEM> -<PARA> -</PARA> -</LISTITEM> -</VARLISTENTRY> -</VARIABLELIST> -<PARA> -</PARA> + <refsect2 id="R2-SQL-INSERT-4"> + <refsect2info> + <date>1998-09-23</date> + </refsect2info> + <title> + SQL92 + </title> + <para> + <command>INSERT</command> is fully compatible with <acronym>SQL92</acronym>. + Possible limitations in features of the + <replaceable class="PARAMETER">query</replaceable> + clause are documented for the SELECT statement. + </para> + </refsect2> + </refsect1> +</refentry> + +<!-- Keep this comment at the end of the file +Local variables: +mode: sgml +sgml-omittag:nil +sgml-shorttag:t +sgml-minimize-attributes:nil +sgml-always-quote-attributes:t +sgml-indent-step:1 +sgml-indent-data:t +sgml-parent-document:nil +sgml-default-dtd-file:"../reference.ced" +sgml-exposed-tags:nil +sgml-local-catalogs:"/usr/lib/sgml/catalog" +sgml-local-ecat-files:nil +End: --> |
