On Thu, 27 Jun 2002 18:38:10 +0200, Hans-Juergen Schoenig
<hs(at)cybertec(dot)at> wrote:
>CREATE FUNCTION myinsert() RETURNS opaque AS '
> BEGIN
> RAISE NOTICE ''1 - NEW: %\n'', NEW.one;
> RAISE NOTICE ''2 - NEW: %\n'', NEW.two;
> RETURN NEW;
> END;
>' LANGUAGE 'plpgsql';
>
>An error is displayed:
>ERROR: function myinsert already exists with same argument types
Hans, you are still running an old version of your function
myinsert(). Better use
CREATE OR REPLACE FUNCTION myinsert() ...
Servus
Manfred