X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 14D73D1C511
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 21 Apr 2004 12:16:10 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 04170-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 21 Apr 2004 12:16:06 -0300 (ADT)
Received: from web13901.mail.yahoo.com (web13901.mail.yahoo.com
	[216.136.175.27])
	by svr1.postgresql.org (Postfix) with SMTP id F13A0D1BABD
	for <pgsql-sql@postgresql.org>; Wed, 21 Apr 2004 12:16:05 -0300 (ADT)
Message-ID: <20040421151605.77039.qmail@web13901.mail.yahoo.com>
Received: from [80.67.100.162] by web13901.mail.yahoo.com via HTTP;
	Wed, 21 Apr 2004 08:16:05 PDT
Date: Wed, 21 Apr 2004 08:16:05 -0700 (PDT)
From: <abief_ag_-postgresql@yahoo.com>
Subject: Trigger calling a function HELP ME! (2)
To: pgsql-sql@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME,
	UPPERCASE_25_50
X-Spam-Level: 
X-Archive-Number: 200404/208
X-Sequence-Number: 17583

Sorry. I realize I slipped an error in my code:
 
 the code is:
 ---
  CREATE TABLE public.imp_test
  (
    id int8,
    value text
  ) WITHOUT OIDS;
  
  CREATE OR REPLACE FUNCTION public.imp_test_to_out_test(imp_test)
    RETURNS imp_test AS
  'begin
   return $1;
 end;'
    LANGUAGE 'plpgsql' STABLE;
  
  CREATE OR REPLACE FUNCTION public.imp_test_trigger()
    RETURNS trigger AS
  'begin
  return imp_test_to_out_test(new);
  end;'
    LANGUAGE 'plpgsql' STABLE;
  
  CREATE TRIGGER imp_test_trigger_001
    BEFORE INSERT OR UPDATE
    ON public.imp_test
    FOR EACH ROW
    EXECUTE PROCEDURE public.imp_test_trigger();
 ---
 
 regards,
 


=====
Riccardo G. Facchini