Received: from candle.pha.pa.us (216-55-132-35.dsl.san-diego.abac.net [216.55.132.35]) by postgresql.org (Postfix) with ESMTP id 7C8AC475D7F for ; Thu, 7 Mar 2002 14:02:32 -0500 (EST) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.10.1) id g27J2A003059; Thu, 7 Mar 2002 14:02:10 -0500 (EST) From: Bruce Momjian Message-Id: <200203071902.g27J2A003059@candle.pha.pa.us> Subject: Re: PostgreSQL TO-DO List (fwd) In-Reply-To: To: Vince Vielhaber Date: Thu, 7 Mar 2002 14:02:10 -0500 (EST) Cc: PostgreSQL-documentation X-Mailer: ELM [version 2.4ME+ PL96 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200203/22 X-Sequence-Number: 1303 Vince Vielhaber wrote: > On Sun, 3 Mar 2002, Bruce Momjian wrote: > > > Can someone comment on this? I don't understand it. > > > > > > The example being referred to is here: > > http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/plpgsql-examples.html > > Scroll to the bottom. Unfortunately I can't go back and read his > comment with the terminal I'm using. The current query in this section is: CREATE FUNCTION c_overpaid (EMP, INTEGER) RETURNS BOOLEAN AS ' DECLARE emprec ALIAS FOR $1; sallim ALIAS FOR $2; BEGIN IF emprec.salary ISNULL THEN RETURN ''f''; END IF; RETURN emprec.salary > sallim; END; ' LANGUAGE 'plpgsql'; Looks OK to me. Seems it has been updated since the report. I can't find a mention of fun1 or fun2 anywhere in the docs anymore. -- Bruce Momjian | http://candle.pha.pa.us 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