Обсуждение: Minor errors in plpgsql and plperl examples..

Hi -

There are two errors involving single quotes in the following documents.

http://www.postgresql.org/docs/user/c40874340.htm
- In the code for "PL/pgSQL Trigger Procedure" the initial single quote is
missing.  Currently the line reads:

   CREATE FUNCTION emp_stamp () RETURNS OPAQUE AS

All the other examples have a single quote right after "AS".



http://www.postgresql.org/docs/user/pl-perl4538.htm
- The last example is:

  CREATE FUNCTION empcomp(employee) returns int4
    AS 'my $emp = shift;
        return $emp->{'basesalary'} + $emp->{'bonus'};'
    LANGUAGE 'plperl';


Shouldn't the single quotes on the "return" line be escaped?


(i've never used postgresql so maybe this is all incorrect, but just
reading through the docs -- which are very very nice btw)

-philip

I have fixed both of these in the current sources.  Thanks much.


> Hi -
>
> There are two errors involving single quotes in the following documents.
>
> http://www.postgresql.org/docs/user/c40874340.htm
> - In the code for "PL/pgSQL Trigger Procedure" the initial single quote is
> missing.  Currently the line reads:
>
>    CREATE FUNCTION emp_stamp () RETURNS OPAQUE AS
>
> All the other examples have a single quote right after "AS".
>
>
>
> http://www.postgresql.org/docs/user/pl-perl4538.htm
> - The last example is:
>
>   CREATE FUNCTION empcomp(employee) returns int4
>     AS 'my $emp = shift;
>         return $emp->{'basesalary'} + $emp->{'bonus'};'
>     LANGUAGE 'plperl';
>
>
> Shouldn't the single quotes on the "return" line be escaped?
>
>
> (i've never used postgresql so maybe this is all incorrect, but just
> reading through the docs -- which are very very nice btw)
>
> -philip
>
>


--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026