aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2014-01-11 14:00:32 -0500
committerBruce Momjian <bruce@momjian.us>2014-01-11 14:00:47 -0500
commitd84c584ece6d882c3a45cacd056ca8635e963996 (patch)
treeddda7cdb0da73ef5708ec88dedfb3bc4db640731
parent6286526207d53e5b31968103adb89b4c9cd21499 (diff)
downloadpostgresql-d84c584ece6d882c3a45cacd056ca8635e963996.tar.gz
postgresql-d84c584ece6d882c3a45cacd056ca8635e963996.zip
Revert fd2ace802811c333b0b4e1a28b138fd4774745f3
Seems we want to document '=' plpgsql assignment instead.
-rw-r--r--doc/src/sgml/plpgsql.sgml30
1 files changed, 15 insertions, 15 deletions
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml
index a9df75062a3..ca2c2b5851b 100644
--- a/doc/src/sgml/plpgsql.sgml
+++ b/doc/src/sgml/plpgsql.sgml
@@ -3932,20 +3932,20 @@ CREATE OR REPLACE FUNCTION update_emp_view() RETURNS TRIGGER AS $$
DELETE FROM emp WHERE empname = OLD.empname;
IF NOT FOUND THEN RETURN NULL; END IF;
- OLD.last_updated := now();
+ OLD.last_updated = now();
INSERT INTO emp_audit VALUES('D', user, OLD.*);
RETURN OLD;
ELSIF (TG_OP = 'UPDATE') THEN
UPDATE emp SET salary = NEW.salary WHERE empname = OLD.empname;
IF NOT FOUND THEN RETURN NULL; END IF;
- NEW.last_updated := now();
+ NEW.last_updated = now();
INSERT INTO emp_audit VALUES('U', user, NEW.*);
RETURN NEW;
ELSIF (TG_OP = 'INSERT') THEN
INSERT INTO emp VALUES(NEW.empname, NEW.salary);
- NEW.last_updated := now();
+ NEW.last_updated = now();
INSERT INTO emp_audit VALUES('I', user, NEW.*);
RETURN NEW;
END IF;
@@ -4030,10 +4030,10 @@ AS $maint_sales_summary_bytime$
-- Work out the increment/decrement amount(s).
IF (TG_OP = 'DELETE') THEN
- delta_time_key := OLD.time_key;
- delta_amount_sold := -1 * OLD.amount_sold;
- delta_units_sold := -1 * OLD.units_sold;
- delta_amount_cost := -1 * OLD.amount_cost;
+ delta_time_key = OLD.time_key;
+ delta_amount_sold = -1 * OLD.amount_sold;
+ delta_units_sold = -1 * OLD.units_sold;
+ delta_amount_cost = -1 * OLD.amount_cost;
ELSIF (TG_OP = 'UPDATE') THEN
@@ -4045,17 +4045,17 @@ AS $maint_sales_summary_bytime$
OLD.time_key, NEW.time_key;
END IF;
- delta_time_key := OLD.time_key;
- delta_amount_sold := NEW.amount_sold - OLD.amount_sold;
- delta_units_sold := NEW.units_sold - OLD.units_sold;
- delta_amount_cost := NEW.amount_cost - OLD.amount_cost;
+ delta_time_key = OLD.time_key;
+ delta_amount_sold = NEW.amount_sold - OLD.amount_sold;
+ delta_units_sold = NEW.units_sold - OLD.units_sold;
+ delta_amount_cost = NEW.amount_cost - OLD.amount_cost;
ELSIF (TG_OP = 'INSERT') THEN
- delta_time_key := NEW.time_key;
- delta_amount_sold := NEW.amount_sold;
- delta_units_sold := NEW.units_sold;
- delta_amount_cost := NEW.amount_cost;
+ delta_time_key = NEW.time_key;
+ delta_amount_sold = NEW.amount_sold;
+ delta_units_sold = NEW.units_sold;
+ delta_amount_cost = NEW.amount_cost;
END IF;