From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200203040255.g242tto08892@candle.pha.pa.us>
Subject: PostgreSQL TO-DO List (fwd)
To: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Date: Sun, 3 Mar 2002 21:55:55 -0500 (EST)
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary=ELM1015210555-5818-0_
Content-Transfer-Encoding: 8bit

--ELM1015210555-5818-0_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

Can someone comment on this?  I don't understand it.

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

--ELM1015210555-5818-0_
Content-Transfer-Encoding: 8bit
Content-Type: message/rfc822
Content-Description: Forwarded message from cnliou@eurosport.com

Return-path: <cnliou@eurosport.com>
Received: from th00.opsion.fr (th00.opsion.fr [195.219.20.10])
	by candle.pha.pa.us (8.11.6/8.10.1) with SMTP id g242mnM07242
	for <pgman@candle.pha.pa.us>; Sun, 3 Mar 2002 21:48:50 -0500 (EST)
Received: from 10.1.1.17 [10.1.1.17] by th00.opsion.fr id 200203040248.1f98;
	Mon, 4 Mar 2002 02:48:31 GMT
Send-By: 211.78.0.219 with Mozilla/4.78 [en] (Win95; U)
To: <pgman@candle.pha.pa.us>
Subject: PostgreSQL TO-DO List
From: <cnliou@eurosport.com>
X-Priority: 3 (normal)
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Date: Mon, 4 Mar 2002 02:48:31 GMT
Message-ID: <200203040248.1f98@th00.opsion.fr>
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by candle.pha.pa.us id
	g242mnM07242

Hi! Bruce,

Many thanks to your great contributions to Pgsql
projects.

I cannot find the following to-fix bug in section
"SERVER-SIDE LANGUAGES" in "PostgreSQL TO-DO List".

Please also refer to:
"Example 23-4. A PL/pgSQL Function on Composite Type"
in integrated on-line document.

Best Regards,

CN

=========================
create table test(f1 integer,f2 integer);
CREATE FUNCTION fun1(test) RETURNS BOOLEAN AS '
DECLARE
  f1 FOR $1.f1;
  f2 FOR $1.f2;
  integer sum;
BEGIN
  sum:=f1+f2;
  raise notice ''f1+f2'',sum;
  RETURN TRUE;
END;' LANGUAGE 'plpgsql';
-----------------------
CREATE FUNCTION fun2() RETURNS OPAQUE AS '
BEGIN
  PERFORM fun1(NEW);
  RETURN NEW;
END;' LANGUAGE 'plpgsql';

CREATE TRIGGER ttest AFTER INSERT ON test FOR EACH
ROW EXECUTE PROCEDURE fun2();
insert into test values(1,2);


NOTICE:  Error occurred while executing PL/pgSQL
function fun2
NOTICE:  line 2 at assignment
ERROR:  NEW used in non-rule query

--------------------------------------------------------
You too can have your own email address from Eurosport.
http://www.eurosport.com


--ELM1015210555-5818-0_--