Why does this not work?

-- Table: test
CREATE TABLE "test" (
  "test1" varchar(10)
) WITH OIDS;

-- Function: laenge()
CREATE FUNCTION "laenge"() RETURNS "opaque" AS '
begin
if length(new.test1) > 10 then
        new.test1 = substr(new.test1,1,9);
end if;
return new;
end
' LANGUAGE 'plpgsql';

-- Trigger: laenge_trig ON test
CREATE TRIGGER "laenge_trig" BEFORE INSERT OR UPDATE ON "test" FOR EACH ROW EXECUTE PROCEDURE laenge();

insert into test (test1) values  ('0123456789012');

value too long for type character varying(10)

regards






Johann Zuschlag
zuschlag@online.de