[SQL] Trigger calling a function HELP ME! (2)

2004-04-26 Thread Riccardo Facchini
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; CREAT

Re: [SQL] Trigger calling a function HELP ME! (2)

2004-04-26 Thread Riccardo G. Facchini
--- Richard Huxton wrote: > On Wednesday 21 April 2004 16:16, abief_ag_-postgresql(AT)yahoo.com > wrote: > > > CREATE OR REPLACE FUNCTION public.imp_test_to_out_test(imp_test) > > RETURNS imp_test AS > > 'begin > >return $1; > > end;' > > LANGUAGE 'plpgsql' STABLE; > > > > CRE

Re: [SQL] Trigger calling a function HELP ME! (2)

2004-04-23 Thread Riccardo G. Facchini
--- Richard Huxton wrote: > On Wednesday 21 April 2004 16:16, abief_ag_-postgresql(at)yahoo.com > wrote: > > > CREATE OR REPLACE FUNCTION public.imp_test_to_out_test(imp_test) > > RETURNS imp_test AS > > 'begin > >return $1; > > end;' > > LANGUAGE 'plpgsql' STABLE; > > > > CREA

Re: [SQL] Trigger calling a function HELP ME! (2)

2004-04-22 Thread Richard Huxton
On Wednesday 21 April 2004 16:16, [EMAIL PROTECTED] wrote: > 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 tr

[SQL] Trigger calling a function HELP ME! (2)

2004-04-21 Thread abief_ag_-postgresql
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' ST

[SQL] Trigger calling a function HELP ME!

2004-04-21 Thread abief_ag_-postgresql
Hi all, first of all, let me explain what I'm trying to do. I have a table with a fairly complicated trigger. In this trigger I have a specific set of codelines that can be executed in more than 50 places that works on the new.* fields in order to fix/clean them. In order to improve readability,