Check constraint problem
From: Julian Goulet <jgoulet_at_whsun1.whoi.edu>
Date: 1995/10/27
Message-ID: <46r9mv$muk_at_pearl.whoi.edu>#1/1
Date: 1995/10/27
Message-ID: <46r9mv$muk_at_pearl.whoi.edu>#1/1
Two of the solutions posted wont work:
check (col between '0' and '9' )etc
will accept a col whose value is '0&$' and reject '9Z'
the first solution posted, but translated to a check rather than a trigger,
check (translate(col,'01234...etc list','XXXXXXXX...etc') =
rpad('X',length(col),'X') )
should work.
Julien Goulet
jgoulet_at_mola.gso.uri.edu
Received on Fri Oct 27 1995 - 00:00:00 CET