Skip to content

Commit 5bd91e3

Browse files
committed
doc: Improve CREATE VIEW / WITH documentation
Similar to 590eb0c, remove the options list from the synopsis and elaborate in the main description.
1 parent f7102b0 commit 5bd91e3

File tree

1 file changed

+9
-14
lines changed

1 file changed

+9
-14
lines changed

doc/src/sgml/ref/create_view.sgml

+9-14
Original file line numberDiff line numberDiff line change
@@ -25,11 +25,6 @@ CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] [ RECURSIVE ] VIEW <replaceable class
2525
[ WITH ( <replaceable class="PARAMETER">view_option_name</replaceable> [= <replaceable class="PARAMETER">view_option_value</replaceable>] [, ... ] ) ]
2626
AS <replaceable class="PARAMETER">query</replaceable>
2727
[ WITH [ CASCADED | LOCAL ] CHECK OPTION ]
28-
29-
<phrase>where <replaceable class="parameter">view_option_name</replaceable> can be one of:</phrase>
30-
31-
security_barrier [ <replaceable class="parameter">boolean</replaceable> ]
32-
check_option [ <replaceable class="parameter">text</replaceable> (<literal>local</literal> or <literal>cascaded</literal>) ]
3328
</synopsis>
3429
</refsynopsisdiv>
3530

@@ -131,24 +126,24 @@ CREATE VIEW <replaceable>name</> AS WITH RECURSIVE <replaceable>name</> (<replac
131126

132127
<variablelist>
133128
<varlistentry>
134-
<term><literal>security_barrier(boolean)</literal></term>
129+
<term><literal>check_option</literal> (<type>string</type>)</term>
135130
<listitem>
136131
<para>
137-
This should be used if the view is intended to provide row-level
138-
security. See <xref linkend="rules-privileges"> for full details.
132+
This parameter may be either <literal>local</> or
133+
<literal>cascaded</>, and is equivalent to specifying
134+
<literal>WITH [ CASCADED | LOCAL ] CHECK OPTION</> (see below).
135+
This option can be changed on existing views using <xref
136+
linkend="sql-alterview">.
139137
</para>
140138
</listitem>
141139
</varlistentry>
142140

143141
<varlistentry>
144-
<term><literal>check_option(text)</literal></term>
142+
<term><literal>security_barrier</literal> (<type>string</type>)</term>
145143
<listitem>
146144
<para>
147-
This parameter may be either <literal>local</> or
148-
<literal>cascaded</>, and is equivalent to specifying
149-
<literal>WITH [ CASCADED | LOCAL ] CHECK OPTION</> (see below).
150-
This option can be changed on existing views using <xref
151-
linkend="sql-alterview">.
145+
This should be used if the view is intended to provide row-level
146+
security. See <xref linkend="rules-privileges"> for full details.
152147
</para>
153148
</listitem>
154149
</varlistentry>

0 commit comments

Comments
 (0)