On Tue, Jul 8, 2008 at 8:09 PM, Ow Mun Heng <[EMAIL PROTECTED]> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
