> > iow, i want to limit the the newly converted
> > revision to 2 characters, but can't due to the
> > 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.
Richard, thank you. i think this does what i want,
however, i want to understand a bit more.
this is an additional defined constraint, correct? is
this constraint added automagically by pgadmin when
you enter a length value or is this a different
method to achieve a similar result?
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
In response to
pgsql-novice by date
|Next:||From: operationsengineer1||Date: 2006-08-31 18:46:29|
|Subject: hyperlinks stored in pgsql|
|Previous:||From: Richard Broersma Jr||Date: 2006-08-31 17:36:56|
|Subject: Re: int4 to varchar length (pgadmin3) issue|