summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/create_view.sgml
diff options
context:
space:
mode:
authorThomas G. Lockhart <lockhart@fourpalms.org>1998-09-22 15:48:03 +0000
committerThomas G. Lockhart <lockhart@fourpalms.org>1998-09-22 15:48:03 +0000
commit52ca2ab26852caf5715f92fa8457eaad4be5e9cc (patch)
treebfbbcd2cc180957a92ba7ddbf8bc435fd7d1f8eb /doc/src/sgml/ref/create_view.sgml
parent748e3003176c94d5db2174e959b46f7745d806a7 (diff)
Editing and markup cleanup.
Diffstat (limited to 'doc/src/sgml/ref/create_view.sgml')
-rw-r--r--doc/src/sgml/ref/create_view.sgml67
1 files changed, 29 insertions, 38 deletions
diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml
index 99b7be53621..07c3d966398 100644
--- a/doc/src/sgml/ref/create_view.sgml
+++ b/doc/src/sgml/ref/create_view.sgml
@@ -14,28 +14,21 @@ Constructs a virtual table
</REFPURPOSE>
<REFSYNOPSISDIV>
<REFSYNOPSISDIVINFO>
- <DATE>1998-04-15</DATE>
+ <DATE>1998-09-21</DATE>
</REFSYNOPSISDIVINFO>
<SYNOPSIS>
- CREATE VIEW <REPLACEABLE CLASS="PARAMETER">view</REPLACEABLE>
- AS SELECT <REPLACEABLE CLASS="PARAMETER">query</REPLACEABLE>
+CREATE VIEW <REPLACEABLE CLASS="PARAMETER">view</REPLACEABLE>
+ AS SELECT <REPLACEABLE CLASS="PARAMETER">query</REPLACEABLE>
</SYNOPSIS>
<REFSECT2 ID="R2-SQL-CREATEVIEW-1">
<REFSECT2INFO>
- <DATE>1998-04-15</DATE>
+ <DATE>1998-09-21</DATE>
</REFSECT2INFO>
<TITLE>
Inputs
</TITLE>
<PARA>
- </PARA>
- <VARIABLELIST>
- <VARLISTENTRY>
- <TERM>
- </TERM>
- <LISTITEM>
- <PARA>
<VARIABLELIST>
<VARLISTENTRY>
<TERM>
@@ -62,14 +55,11 @@ An SQL query which will provide the columns and rows of the view.
</LISTITEM>
</VARLISTENTRY>
</variablelist>
- </LISTITEM>
- </VARLISTENTRY>
- </VARIABLELIST>
</REFSECT2>
<REFSECT2 ID="R2-SQL-CREATEVIEW-2">
<REFSECT2INFO>
- <DATE>1998-04-15</DATE>
+ <DATE>1998-09-21</DATE>
</REFSECT2INFO>
<TITLE>
Outputs
@@ -79,6 +69,7 @@ An SQL query which will provide the columns and rows of the view.
<VARIABLELIST>
<VARLISTENTRY>
<TERM>
+<replaceable>status</replaceable>
</TERM>
<LISTITEM>
<PARA>
@@ -133,7 +124,7 @@ An SQL query which will provide the columns and rows of the view.
<REFSECT1 ID="R1-SQL-CREATEVIEW-1">
<REFSECT1INFO>
- <DATE>1998-04-15</DATE>
+ <DATE>1998-09-21</DATE>
</REFSECT1INFO>
<TITLE>
Description
@@ -147,7 +138,7 @@ An SQL query which will provide the columns and rows of the view.
<REFSECT2 ID="R2-SQL-CREATEVIEW-3">
<REFSECT2INFO>
- <DATE>1998-04-15</DATE>
+ <DATE>1998-09-21</DATE>
</REFSECT2INFO>
<TITLE>
Notes
@@ -159,7 +150,7 @@ An SQL query which will provide the columns and rows of the view.
<REFSECT2 ID="R2-SQL-CREATEVIEW-4">
<REFSECT2INFO>
- <DATE>1998-04-15</DATE>
+ <DATE>1998-09-21</DATE>
</REFSECT2INFO>
<TITLE>
Bugs
@@ -177,17 +168,17 @@ An SQL query which will provide the columns and rows of the view.
Create a view consisting of all Comedy films:
</PARA>
<ProgramListing>
- CREATE VIEW kinds AS
- SELECT *
- FROM films
- WHERE kind = 'Comedy';
+CREATE VIEW kinds AS
+ SELECT *
+ FROM films
+ WHERE kind = 'Comedy';
- SELECT * FROM kinds;
+SELECT * FROM kinds;
- code |title |did| date_prod|kind |len
- -----+-------------------------+---+----------+----------+------
- UA502|Bananas |105|1971-07-13|Comedy | 01:22
- C_701|There's a Girl in my Soup|107|1970-06-11|Comedy | 01:36
+code |title |did| date_prod|kind |len
+-----+-------------------------+---+----------+----------+------
+UA502|Bananas |105|1971-07-13|Comedy | 01:22
+C_701|There's a Girl in my Soup|107|1970-06-11|Comedy | 01:36
</ProgramListing>
</REFSECT1>
@@ -201,7 +192,7 @@ An SQL query which will provide the columns and rows of the view.
<REFSECT2 ID="R2-SQL-CREATEVIEW-5">
<REFSECT2INFO>
- <DATE>1998-04-15</DATE>
+ <DATE>1998-09-21</DATE>
</REFSECT2INFO>
<TITLE>
SQL92
@@ -209,13 +200,13 @@ An SQL query which will provide the columns and rows of the view.
<PARA>
SQL92 specifies some additional capabilities for the CREATE VIEW statement:
</PARA>
- <programlisting>
- CREATE VIEW <replaceable class="parameter">view</replaceable> [ <replaceable class="parameter">column</replaceable> [, ...] ]
- AS SELECT <replaceable class="parameter">expression</replaceable> [AS <replaceable class="parameter">colname</replaceable>] [, ...]
- FROM <replaceable class="parameter">table</replaceable>
- [WHERE <replaceable class="parameter">condition</replaceable>]
- [ WITH [ CASCADE | LOCAL ] CHECK OPTION ]
- </programlisting>
+ <synopsis>
+CREATE VIEW <replaceable class="parameter">view</replaceable> [ <replaceable class="parameter">column</replaceable> [, ...] ]
+ AS SELECT <replaceable class="parameter">expression</replaceable> [AS <replaceable class="parameter">colname</replaceable>] [, ...]
+ FROM <replaceable class="parameter">table</replaceable>
+ [ WHERE <replaceable class="parameter">condition</replaceable> ]
+ [ WITH [ CASCADE | LOCAL ] CHECK OPTION ]
+ </synopsis>
<VARIABLELIST>
<VARLISTENTRY>
@@ -226,7 +217,7 @@ An SQL query which will provide the columns and rows of the view.
<VARIABLELIST>
<VARLISTENTRY>
<TERM>
- <ReturnValue>CHECK OPTION</ReturnValue>
+ CHECK OPTION
</TERM>
<LISTITEM>
<PARA> This option is to do with updatable views.
@@ -238,7 +229,7 @@ An SQL query which will provide the columns and rows of the view.
</VARLISTENTRY>
<VARLISTENTRY>
<TERM>
- <ReturnValue>LOCAL</ReturnValue>
+ LOCAL
</TERM>
<LISTITEM>
<PARA>
@@ -248,7 +239,7 @@ An SQL query which will provide the columns and rows of the view.
</VARLISTENTRY>
<VARLISTENTRY>
<TERM>
- <ReturnValue>CASCADE</ReturnValue>
+ CASCADE
</TERM>
<LISTITEM>
<PARA>