diff options
| author | Stephen Frost <sfrost@snowman.net> | 2015-01-28 23:21:54 -0500 |
|---|---|---|
| committer | Stephen Frost <sfrost@snowman.net> | 2015-01-28 23:21:54 -0500 |
| commit | 1c993b3aceb7e0ccf32b59280b266b1f4f7b077e (patch) | |
| tree | 7c0bd693b83a0d55b7cc6ae218ce7911914e33a8 | |
| parent | bb541812b8f67ae0341fa76fe3bb60f58671b8c7 (diff) | |
Reword CREATE POLICY parameter descriptions
The parameter description for the using_expression and check_expression
in CREATE POLICY were unclear and arguably included a typo. Clarify
and improve the consistency of that language.
Pointed out by Dean Rasheed.
| -rw-r--r-- | doc/src/sgml/ref/create_policy.sgml | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/doc/src/sgml/ref/create_policy.sgml b/doc/src/sgml/ref/create_policy.sgml index cf464cb51f1..646b08d51b5 100644 --- a/doc/src/sgml/ref/create_policy.sgml +++ b/doc/src/sgml/ref/create_policy.sgml @@ -158,7 +158,8 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable Any <acronym>SQL</acronym> conditional expression (returning <type>boolean</type>). The conditional expression cannot contain any aggregate or window functions. This expression will be added - to queries to filter out the records which are visible to the query. + to queries that refer to the table if row level security is enabled, + and will allow access to rows matching the expression. </para> </listitem> </varlistentry> @@ -168,11 +169,12 @@ CREATE POLICY <replaceable class="parameter">name</replaceable> ON <replaceable <listitem> <para> Any <acronym>SQL</acronym> conditional expression (returning - <type>boolean</type>). The condition expression cannot contain - any aggregate or window functions. This expression will be added - to queries which are attempting to add records to the table as - with-check options, and an error will be thrown if this condition - returns false for any records being added. + <type>boolean</type>). The conditional expression cannot contain + any aggregate or window functions. This expression will be used with + <command>INSERT</command> and <command>UPDATE</command> queries against + the table if row level security is enabled and an error will be thrown + if the expression evaluates to false for any of the records inserted + or any of the records which result from the update. </para> </listitem> </varlistentry> |