public inbox for [email protected]  

help / color / mirror / Atom feed

From: Pavel Stehule <[email protected]>
To: pgsql-docs <[email protected]>
Subject: remove undocumented assign syntax from plpgsql doc
Date: Wed, 29 May 2013 10:02:20 +0200
Message-ID: <CAFj8pRDHJqRwZd-GO1t3WnLnS--E943xPrEUSOT_nL8xr9mE2g@mail.gmail.com> (raw)
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

Hello

remove undocumented syntax for assign statements in plpgsql doc examples

related to http://www.postgresql.org/message-id/[email protected]....
thread

Regards

Pavel Stehule


-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Attachments:

  [application/octet-stream] plpgsql-assign.patch (2.8K, 2-plpgsql-assign.patch)
  download | inline diff:
diff --git a/doc/src/sgml/plpgsql.sgml b/doc/src/sgml/plpgsql.sgml
index 19498c6..1817c9d 100644
--- a/doc/src/sgml/plpgsql.sgml
+++ b/doc/src/sgml/plpgsql.sgml
@@ -3815,20 +3815,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;
@@ -3913,10 +3913,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
 
@@ -3928,17 +3928,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;
 

view thread (27+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: remove undocumented assign syntax from plpgsql doc
  In-Reply-To: <CAFj8pRDHJqRwZd-GO1t3WnLnS--E943xPrEUSOT_nL8xr9mE2g@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox