Horton

Re: unique constraint - bug?

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: mikeo <mikeo@spectrumtelecorp.com>
Cc: "Oliver Elphick" <olly@lfix.co.uk>, pgsql-general@postgresql.org
Date: 2000-07-20T15:25:10Z
Lists: pgsql-general 
mikeo <mikeo@spectrumtelecorp.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