> iow, i want to limit the the newly converted varchar
> revision to 2 characters, but can't due to the grayed
> out boxes in pgadmin3.
I saw this example at:
ALTER TABLE distributors ADD CONSTRAINT zipchk CHECK (char_length(zipcode) = 5);
This should do what you want.
Richard Broersma Jr.
In response to
pgsql-novice by date
|Next:||From: operationsengineer1||Date: 2006-08-31 18:41:05|
|Subject: Re: int4 to varchar length (pgadmin3) issue|
|Previous:||From: operationsengineer1||Date: 2006-08-31 17:21:21|
|Subject: int4 to varchar length (pgadmin3) issue|