summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/insert.sgml
diff options
context:
space:
mode:
authorThomas G. Lockhart <lockhart@fourpalms.org>1999-07-06 17:16:42 +0000
committerThomas G. Lockhart <lockhart@fourpalms.org>1999-07-06 17:16:42 +0000
commita4ac2f458e8cb76177254f4bd7bbd885991379af (patch)
tree278de40d122f67db3a6694319b0d3b6880eba752 /doc/src/sgml/ref/insert.sgml
parent192a66e3dad33ff8aa446c4c053f0b01498549f5 (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.sgml458
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>&bull;
-</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:
-->