Re: [GENERAL] unique key issue

On Mon, Sep 18, 2006 at 03:54:05PM -0700, Junkone wrote: > HI > I have a table with a unique key constraint on col1,col2. The dattabase > allowed an multiple inserts. here is how > > col1 col2 > 'abc' > 'abc' Depends on what you mean by . If you mean NULL, then it's a

Re: [GENERAL] unique key issue

Junkone wrote: HI I have a table with a unique key constraint on col1,col2. The dattabase allowed an multiple inserts. here is how col1 col2 'abc' 'abc' I suppose the values in col2 are NULL values? You cannot compare NULL values. NULL == NULL evaluates to NULL (n

[GENERAL] unique key issue

HI I have a table with a unique key constraint on col1,col2. The dattabase allowed an multiple inserts. here is how col1 col2 'abc' 'abc' I am not sure how this can happen ---(end of broadcast)--- TIP 1: if posting/rea