X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1112B475FD9 for ; Tue, 1 Apr 2003 09:34:40 -0500 (EST) Received: from smtp015.mail.yahoo.com (smtp015.mail.yahoo.com [216.136.173.59]) by postgresql.org (Postfix) with SMTP id 5C7C1475F3D for ; Tue, 1 Apr 2003 09:34:39 -0500 (EST) Received: from red01.utm.mx (HELO localhost) (ksql2002@192.100.170.191 with plain) by smtp.mail.vip.sc5.yahoo.com with SMTP; 1 Apr 2003 14:34:42 -0000 Date: Tue, 1 Apr 2003 08:34:48 -0600 From: Luis Mix X-Mailer: The Bat! (v1.61) Reply-To: Luis Mix Organization: utm X-Priority: 3 (Normal) Message-ID: <143697787.20030401083448@yahoo.com.mx> To: pgsql-sql@postgresql.org Subject: How can I quit this: "Unique " to my table? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-0.3 required=5.0 tests=BAYES_30,FROM_ENDS_IN_NUMS,MAILTO_TO_SPAM_ADDR version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/2 X-Sequence-Number: 12703 Hello pgsql-sql, When my table was create I wrote this: MyDatabase=# create table b_prestamo(no_inventa char(16) unique not null, cve_area char(10), date1 date); I need now that my table can accept repeated records, but not Null. How can I do that? SomeBody can help me please? My table has information at the moment,what can I do for maintain it? -- Best regards, Luis mailto:ksql2002@yahoo.com.mx