Re: Why does this not work? - Mailing list pgsql-general

On Thu, 11 Apr 2002 10:54:42 -0700 (PDT), Stephan Szabo wrote:

>> -- 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)
>
>The value is being coerced into the type before your trigger
>runs to be put into the values you're testing and it fails
>at that point.

Is there a solution for such a problem?
Let's assume you can't be sure whether you get
the appropriate length in an insert.

Thanks for your help,

regards

Johann Zuschlag
zuschlag@online.de