Re: remove undocumented assign syntax from plpgsql doc

Applied.

---------------------------------------------------------------------------

On Wed, May 29, 2013 at 10:02:20AM +0200, Pavel Stehule wrote:
> Hello
>
> remove undocumented syntax for assign statements in plpgsql doc examples
>
> related to http://www.postgresql.org/message-id/CAJ4CxLkBFNAAsWdz=CsDkU1nC0De60WO15de=aUf6Q1W9DSj7w@mail.gmail.com
> thread
>
> Regards
>
> Pavel Stehule

> 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;
>

>
> --
> Sent via pgsql-docs mailing list (pgsql-docs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-docs

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +