Re: unique constraint - bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mikeo <mikeo(at)spectrumtelecorp(dot)com>
Cc: "Oliver Elphick" <olly(at)lfix(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: unique constraint - bug?
Date: 2000-07-20 15:25:10
Message-ID: 24945.964106710@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

mikeo <mikeo(at)spectrumtelecorp(dot)com> writes:
> insert into x values ('1','','3');

> insert into x values ('1','','3')
> *
> ERROR at line 1:
> ORA-00001: unique constraint (DBA_USER.XIDX) violated

> i'd say that it finds 1,null,3 equal the 2nd time around...

Surely '' does not mean NULL, especially not in a CHAR() column.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philip Warner 2000-07-20 15:35:29 Re: unique constraint - bug?
Previous Message Tom Lane 2000-07-20 15:17:59 Re: [HACKERS] 8Ko limitation