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' <empty space> > 'abc' <empty space>
Depends on what you mean by <empty space>. If you mean NULL, then it's according to the SQL standard. NULL <> NULL so those rows are not equal. If you mean some real value, then yes, that's wierd. Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
signature.asc
Description: Digital signature
