public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bruce Momjian <[email protected]>
To: Pavel Stehule <[email protected]>
Cc: pgsql-docs <[email protected]>
Subject: Re: remove undocumented assign syntax from plpgsql doc
Date: Sat, 11 Jan 2014 13:41:06 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAFj8pRDHJqRwZd-GO1t3WnLnS--E943xPrEUSOT_nL8xr9mE2g@mail.gmail.com>
References: <CAFj8pRDHJqRwZd-GO1t3WnLnS--E943xPrEUSOT_nL8xr9mE2g@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>


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/[email protected]....
> 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 ([email protected])
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-docs


-- 
  Bruce Momjian  <[email protected]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


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

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], [email protected]
  Subject: Re: remove undocumented assign syntax from plpgsql doc
  In-Reply-To: <[email protected]>

* 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