On Tue, Jul 8, 2008 at 8:09 PM, Ow Mun Heng <Ow.Mun.Heng@wdc.com> wrote:
> It was varchar(4) for a _long_ time until there came a need recently to
> move it to a 5 characters.
> Hence the issue, I've already changed it to varchar() instead to make it
> more open (and less problematic in the future)
To prevent this issue from re-occuring in the future, you could use
text and then add a check( length( col ) <= 5 ).
--
Regards,
Richard Broersma Jr.
Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug