Re: Is Dropping a column "CHECK" constraint possible?

Hi ,

i want to enforce that a coulumn 'imp'
shud either contain valid data or no data at all.

by valid data i mean data having at least one non whitespace character.

will this constraint be approprote for accomplishing it?

tradein_client=> ALTER TABLE t_a ADD CHECK ( length( btrim(imp) ) > 1 or imp is NULL );

regards
mallah.

On Saturday 06 July 2002 10:05, Christopher Kings-Lynne wrote:
> > can anyone please help?
> > i have a to drop a check contstraint from a column. eg
> >
> > tradein_clients=# \d t_a
> > Table "t_a"
> > Column | Type | Modifiers
> > ------------+---------+-----------
> > company_id | integer |
> > exp | text |
> > imp | text |
> > Check constraints: "$1" (length(imp) > 1)
> > "aaaaaq" (length(imp) > 1)
> >