Received: from candle.pha.pa.us (pgman@s5-03.ppp.op.net [209.152.195.67]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA95979 for ; Tue, 9 May 2000 14:27:24 -0400 (EDT) (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id OAA27039; Tue, 9 May 2000 14:25:41 -0400 (EDT) From: Bruce Momjian Message-Id: <200005091825.OAA27039@candle.pha.pa.us> Subject: Re: Minor errors in plpgsql and plperl examples.. In-Reply-To: from Philip Hallstrom at "May 9, 2000 11:08:56 am" To: Philip Hallstrom Date: Tue, 9 May 2000 14:25:41 -0400 (EDT) CC: pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL72 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/9 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