Re: Create Table Unique problem... bug? - Mailing list pgsql-novice

From Nabil Sayegh
Subject Re: Create Table Unique problem... bug?
Date
Msg-id 1054129826.1504.10.camel@billy
Whole thread Raw
In response to Create Table Unique problem... bug?  (Mauro Bertoli <bertolima@yahoo.it>)
List pgsql-novice
Am Mit, 2003-05-28 um 15.34 schrieb Mauro Bertoli:
> and re-insert it... I can!!!! Now there are two
> identical row, and UNIQUE??
> I think postgres must occur an error? Is it Ok?
>
> (The same problem is with:
> INSERT INTO questiontypes (id,label) values (2,'a');
> Is it ok?)

I don't know the answer to your question, but I think the problem could
be that you NULL compared with anything will always be undefined.

e.g. NULL=NULL is false

maybe: (NULL,'a')=(NULL,'a') is false, too ?

bye
--
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : http://www.e-trolley.de


pgsql-novice by date:

Previous
From: Dima Tkach
Date:
Subject: Re: why doesn't an index help my simple query?
Next
From: "ling"
Date:
Subject: FOR UPDATE NOWAIT