From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | Richard Broersma Jr <rabroersma(at)yahoo(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: int4 to varchar length (pgadmin3) issue |
Date: | 2006-08-31 18:41:05 |
Message-ID: | 20060831184106.86238.qmail@web33311.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
> > 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:
>
http://www.postgresql.org/docs/8.1/interactive/sql-altertable.html
>
> ALTER TABLE distributors ADD CONSTRAINT zipchk CHECK
> (char_length(zipcode) = 5);
>
> This should do what you want.
>
> Regards,
>
> 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?
tia..
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | operationsengineer1 | 2006-08-31 18:46:29 | hyperlinks stored in pgsql |
Previous Message | Richard Broersma Jr | 2006-08-31 17:36:56 | Re: int4 to varchar length (pgadmin3) issue |