On Tue, Apr 26, 2005 at 09:49:05AM -0400, Mario Soto Cordones <msotocl@xxxxxxxxx> wrote a message of 45 lines which said: > Hi for all , plese a question ,this function can be write in pl/pgsql ??????? I do not understand, it IS pl/pgsql. > > CREATE OR REPLACE FUNCTION check_immutable() RETURNS TRIGGER > > AS 'BEGIN > > IF NEW.id != OLD.id OR NEW.created != OLD.created THEN > > RAISE EXCEPTION ''Change not allowed in that table''; > > END IF; > > RETURN NEW; > > END;' > > LANGUAGE PLPGSQL; ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org