Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E223D9FB38A for ; Thu, 26 Apr 2007 01:41:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 60390-10 for ; Thu, 26 Apr 2007 01:41:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 7EE0A9FB33B for ; Thu, 26 Apr 2007 01:41:51 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from ns2.instrumentalyst.com (blk-222-55-203.eastlink.ca [24.222.55.203]) by svr4.postgresql.org (Postfix) with ESMTP id DB7D65AF027 for ; Thu, 26 Apr 2007 04:41:50 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by ns2.instrumentalyst.com (Postfix) with ESMTP id B9C0A150E for ; Thu, 26 Apr 2007 01:41:09 -0300 (ADT) X-Virus-Scanned: amavisd-new at instrumentalyst.com Received: from ns2.instrumentalyst.com ([127.0.0.1]) by localhost (ns2.instrumentalyst.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id angIy-bwF+lG for ; Thu, 26 Apr 2007 01:41:06 -0300 (ADT) Received: from murdoc.home (pool-71-180-50-145.tampfl.fios.verizon.net [71.180.50.145]) by ns2.instrumentalyst.com (Postfix) with ESMTP id 4001F14FC for ; Thu, 26 Apr 2007 01:41:06 -0300 (ADT) Message-ID: <46302D88.7070804@productivitymedia.com> Date: Thu, 26 Apr 2007 00:41:44 -0400 From: PostgreSQL Admin User-Agent: Thunderbird 2.0.0.0 (Macintosh/20070326) MIME-Version: 1.0 To: PostgreSQL SQL List Subject: Add constraint for number of chars Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.186 tagged_above=0 required=5 tests=AWL=0.050, BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200704/256 X-Sequence-Number: 28256 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