Subject | can i use UDFs with CHECK constraint (trigger) ? |
---|---|
Author | Kamlesh |
Post date | 2004-03-17T18:58:45Z |
dear friends
i m having many fields in many tables which are required to have some
minimum length strings
so i thought to define DOMAIN for such kind of field, like following
CREATE DOMAIN CODENAME VARCHAR(50) CHECK ( strlen( Value ) > 5 ) );
but it generates error,
is there any way to use UDFs in CHECK constraints , so that i dont have to
write same code in all triggers
Thanks
Kamlesh
i m having many fields in many tables which are required to have some
minimum length strings
so i thought to define DOMAIN for such kind of field, like following
CREATE DOMAIN CODENAME VARCHAR(50) CHECK ( strlen( Value ) > 5 ) );
but it generates error,
is there any way to use UDFs in CHECK constraints , so that i dont have to
write same code in all triggers
Thanks
Kamlesh