Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 872F84761FD for ; Wed, 16 Oct 2002 13:43:19 -0400 (EDT) Received: from www.optimumdigital.com (unknown [64.245.24.5]) by postgresql.org (Postfix) with ESMTP id C80C9476002 for ; Wed, 16 Oct 2002 13:43:18 -0400 (EDT) Received: from xaymaca.com ([63.115.42.135]) by www.optimumdigital.com (8.11.6/8.11.6) with ESMTP id g9GHgJn14143 for ; Wed, 16 Oct 2002 13:42:19 -0400 Message-ID: <3DADA52B.1020507@xaymaca.com> Date: Wed, 16 Oct 2002 13:43:07 -0400 From: Vincent Stoessel User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2b) Gecko/20021007 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Quick contraint question Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/181 X-Sequence-Number: 9898 I have a table that has a frild called ID. I will be inserting data into that field that will either be a unique number or blank, Is there a way to do this either at table creation time or by using some check() voodoo? Thanks. -- Vincent Stoessel Linux Systems Developer vincent xaymaca.com