Hi, This is seemly simple, but I'm @ a loss this early in the morning. It's best explained this way
SAMPLE ----------------------------------- id | serial | username | varchar(100)| constraint username >=8 and username <=100 The problem is that it's characters not integers or numeric. It my constraint correct? Thanks for the help, J ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org