Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3A87E476C16
	for <pgsql-sql@postgresql.org>; Fri,  8 Nov 2002 22:52:08 -0500 (EST)
Received: from mail_dns.lagoon.nc (ns1.offratel.nc [209.58.55.28])
	by postgresql.org (Postfix) with ESMTP id A68A0476C0F
	for <pgsql-sql@postgresql.org>; Fri,  8 Nov 2002 22:52:05 -0500 (EST)
Received: from rack (host-202-22-141-63.offratel.nc [202.22.141.63]) by
	mail_dns.lagoon.nc
	(Rockliffe SMTPRA 4.5.6) with SMTP id <B0014081061@mail_dns.lagoon.nc>;
	Sat, 9 Nov 2002 14:51:47 +1100
Date: Sat, 9 Nov 2002 14:52:11 +0000
From: Emmanuel Engelhart <"Emmanuel Engelhart"@postgresql.org>
To: pgsql-sql@postgresql.org
Cc: emmanuel.engelhart@epita.fr
Subject: CREATE VIEW (dynamically)
Message-Id: <20021109145211.260cb84f.Emmanuel Engelhart@rack>
Reply-To: emmanuel.engelhart@epita.fr
Organization: [Ecole Pour l'Informatique et les Technologies Avanc
X-Mailer: Sylpheed version 0.7.4claws (GTK+ 1.2.10; i386-debian-linux-gnu)
X-Face: 
 .yA/kR]jt1}=pDmgdL:c\yRPc*9ZB\'-Go}-odUxl1Gw=`QsX)Kyn`p"sRjsOCm0}[gPR{\
	EjNjQPJlD&rzsP)[z9.d6anUG.4;
	0pZ0,*HI,HWb[]u't3x#|7i_G<[>)F0\.&:}%13HuQUvH5iWpd !^$5>8J8'uD_V1;
	x"_SJ=>=Hs82t=GjFlDH1LiKSWam+AF{"Z[Q2\D
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/176
X-Sequence-Number: 10318

code
<<
CREATE FUNCTION "requests_insert_after" () RETURNS opaque AS '
DECLARE
	view_name	text;
BEGIN
	view_name := ''request_'' || NEW.id;
	CREATE VIEW view_name AS select * from groups;
	return NEW;
END' LANGUAGE 'plpgsql';

CREATE TRIGGER "requests_insert_after" AFTER INSERT ON "requests"  FOR EACH ROW
EXECUTE PROCEDURE "requests_insert_after" ();>>

This code after an insertion on table "requests" give me this message :
<<
PostgreSQL said: ERROR: parser: parse error at or near "$1" 
>>

Why ?

Thx for any help.

Emmanuel Engelhart