How can I quit this: "Unique " to my table?

From: Luis Mix <ksql2002(at)yahoo(dot)com(dot)mx>
To: pgsql-sql(at)postgresql(dot)org
Subject: How can I quit this: "Unique " to my table?
Date: 2003-04-01 14:34:48
Message-ID: 143697787.20030401083448@yahoo.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)yahoo(dot)com(dot)mx

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ian Barwick 2003-04-01 15:15:54 Re: How can I quit this: "Unique " to my table?
Previous Message Thomas Kellerer 2003-04-01 09:53:45 Re: create view with numeric data