From 8e0f8630a64e6b3ab239053f1eaa554ec1b59d3f Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Sat, 7 Apr 2007 03:48:25 +0000
Subject: [PATCH] Remove example of SQL-standard syntax for GRANT/REVOKE ---
 was causing confusion.

---
 doc/src/sgml/ref/grant.sgml  | 12 +++---------
 doc/src/sgml/ref/revoke.sgml | 13 +++----------
 2 files changed, 6 insertions(+), 19 deletions(-)

diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml
index 080df2b044a..a4c3b0d4408 100644
--- a/doc/src/sgml/ref/grant.sgml
+++ b/doc/src/sgml/ref/grant.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.64 2007/02/01 00:28:19 momjian Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.65 2007/04/07 03:48:25 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -520,14 +520,8 @@ GRANT admins TO joe;
    </para>
 
    <para>
-    The SQL standard allows setting privileges for individual columns
-    within a table:
-
-<synopsis>
-GRANT <replaceable class="PARAMETER">privileges</replaceable>
-    ON <replaceable class="PARAMETER">table</replaceable> [ ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) ] [, ...]
-    TO { PUBLIC | <replaceable class="PARAMETER">username</replaceable> [, ...] } [ WITH GRANT OPTION ]
-</synopsis>
+    <productname>PostgreSQL</productname> does not support the SQL-standard 
+    functionality of setting privileges for individual columns.
    </para>
 
    <para>
diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml
index caf62b78331..412da611e2d 100644
--- a/doc/src/sgml/ref/revoke.sgml
+++ b/doc/src/sgml/ref/revoke.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/revoke.sgml,v 1.42 2007/01/31 23:26:04 momjian Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/revoke.sgml,v 1.43 2007/04/07 03:48:25 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -231,15 +231,8 @@ REVOKE admins FROM joe;
 
    <para>
     The compatibility notes of the <xref linkend="sql-grant" endterm="sql-grant-title"> command
-    apply analogously to <command>REVOKE</command>.  The syntax summary is:
-
-<synopsis>
-REVOKE [ GRANT OPTION FOR ] <replaceable class="PARAMETER">privileges</replaceable>
-    ON <replaceable class="parameter">object</replaceable> [ ( <replaceable class="parameter">column</replaceable> [, ...] ) ]
-    FROM { PUBLIC | <replaceable class="parameter">username</replaceable> [, ...] }
-    { RESTRICT | CASCADE }
-</synopsis>
-    One of <literal>RESTRICT</literal> or <literal>CASCADE</literal>
+    apply analogously to <command>REVOKE</command>.
+    <literal>RESTRICT</literal> or <literal>CASCADE</literal>
     is required according to the standard, but <productname>PostgreSQL</>
     assumes <literal>RESTRICT</literal> by default.
    </para>
-- 
2.39.5