File tree Expand file tree Collapse file tree 1 file<
8000
!-- --> changed +8
-6
lines changed Expand file tree Collapse file tree 1 file changed +8
-6
lines changed Original file line number Diff line number Diff line change @@ -158,7 +158,8 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable
158
158
Any <acronym>SQL</acronym> conditional expression (returning
159
159
<type>boolean</type>). The conditional expression cannot contain
160
160
any aggregate or window functions. This expression will be added
161
- to queries to filter out the records which are visible to the query.
161
+ to queries that refer to the table if row level security is enabled,
162
+ and will allow access to rows matching the expression.
162
163
</para>
163
164
</listitem>
164
165
</varlistentry>
@@ -168,11 +169,12 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable
168
169
<listitem>
169
170
<para>
170
171
Any <acronym>SQL</acronym> conditional expression (returning
171
- <type>boolean</type>). The condition expression cannot contain
172
- any aggregate or window functions. This expression will be added
173
- to queries which are attempting to add records to the table as
174
- with-check options, and an error will be thrown if this condition
175
- returns false for any records being added.
172
+ <type>boolean</type>). The conditional expression cannot contain
173
+ any aggregate or window functions. This expression will be used with
174
+ <command>INSERT</command> and <command>UPDATE</command> queries against
175
+ the table if row level security is enabled and an error will be thrown
176
+ if the expression evaluates to false for any of the records inserted
177
+ or any of the records which result from the update.
176
178
</para>
177
179
</listitem>
178
180
</varlistentry>
You can’t perform that action at this time.
0 commit comments