summaryrefslogtreecommitdiff
path: root/src/man/create_rule.l
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>1999-02-02 17:46:17 +0000
committerBruce Momjian <bruce@momjian.us>1999-02-02 17:46:17 +0000
commit8e958b8a38611e3c62d069af3e3dbc76c1a8a41f (patch)
tree5d122dca8bb0718b71978e290f02aaf782d35e17 /src/man/create_rule.l
parent7ab88a16a111cb1c6c6ac67702c7772cf94bf1bf (diff)
Fix create_rule is->as.
Diffstat (limited to 'src/man/create_rule.l')
-rw-r--r--src/man/create_rule.l16
1 files changed, 8 insertions, 8 deletions
diff --git a/src/man/create_rule.l b/src/man/create_rule.l
index d83749f7bae..a30485ffe16 100644
--- a/src/man/create_rule.l
+++ b/src/man/create_rule.l
@@ -1,6 +1,6 @@
.\" This is -*-nroff-*-
.\" XXX standard disclaimer belongs here....
-.\" $Header: /cvsroot/pgsql/src/man/Attic/create_rule.l,v 1.9 1998/06/24 13:21:24 momjian Exp $
+.\" $Header: /cvsroot/pgsql/src/man/Attic/create_rule.l,v 1.10 1999/02/02 17:46:17 momjian Exp $
.TH "CREATE RULE" SQL 11/05/95 PostgreSQL PostgreSQL
.SH NAME
create rule - define a new rule
@@ -124,11 +124,11 @@ Postgres to
--
--Example of a circular rewrite rule combination.
--
-create rule bad_rule_combination_1 is
+create rule bad_rule_combination_1 as
on select to EMP
do instead select to TOYEMP
-create rule bad_rule_combination_2 is
+create rule bad_rule_combination_2 as
on select to TOYEMP
do instead select to EMP
@@ -146,7 +146,7 @@ access to a class in order to define a rule on it.
--
--Make Sam get the same salary adjustment as Joe
--
-create rule example_1 is
+create rule example_1 as
on update EMP.salary where current.name = "Joe"
do update EMP (salary = new.salary)
where EMP.name = "Sam"
@@ -161,7 +161,7 @@ Joe's salary on to Sam.
--
--Make Bill get Joe's salary when it is accessed
--
-create rule example_2 is
+create rule example_2 as
on select to EMP.salary
where current.name = "Bill"
do instead
@@ -172,7 +172,7 @@ create rule example_2 is
--Deny Joe access to the salary of employees in the shoe
--department. (pg_username() returns the name of the current user)
--
-create rule example_3 is
+create rule example_3 as
on select to EMP.salary
where current.dept = "shoe"
and pg_username() = "Joe"
@@ -184,7 +184,7 @@ create rule example_3 is
--
create TOYEMP(name = name, salary = int4)
-create rule example_4 is
+create rule example_4 as
on select to TOYEMP
do instead select (EMP.name, EMP.salary) from EMP
where EMP.dept = "toy"
@@ -193,7 +193,7 @@ create rule example_4 is
--
--All new employees must make 5,000 or less
--
-create rule example_5 is
+create rule example_5 as
on insert to EMP where new.salary > 5000
do update newset salary = 5000
.fi