Re: How to enforce a string format in a field??

"Ramon F Herrera" <ramon_at_conexus.net> a écrit dans le message de news:c9bc36ff.0411270245.4145eb43_at_posting.google.com...
> My database contains a field called 'SSN' whose
> contents should be obvious.
>
> Is there any way to constrain that field to the
> following format: ddd-dd-dddd? That is: if there is
> an attempt to insert a value that doesn't have 9 digits
> with the hyphens in the proper places, the record should
> be rejected.
>
> Or is this something that I should check before inserting
> the data into the table (for instance, making sure that
> the *.dat file only contains proper SSN values)??
>
> TIA,
>
> -Ramon F Herrera

alter table mytable add constraint myct
check (regexp_like(myfield,'^[:digit:]{3}-[:digit:]{2}-[:digit:]{4}$'));

-- 
Regards
Michel Cadot