From 1c993b3aceb7e0ccf32b59280b266b1f4f7b077e Mon Sep 17 00:00:00 2001 From: Stephen Frost Date: Wed, 28 Jan 2015 23:21:54 -0500 Subject: [PATCH] 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. --- doc/src/sgml/ref/create_policy.sgml | 14 ++++++++------ 1 file 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 name ON SQL conditional expression (returning boolean). 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. @@ -168,11 +169,12 @@ CREATE POLICY name ON Any SQL conditional expression (returning - boolean). 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. + boolean). The conditional expression cannot contain + any aggregate or window functions. This expression will be used with + INSERT and UPDATE 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. -- 2.30.2