Re: Create Table Unique problem... bug?

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