Subject | Re: [Firebird-Architect] unique constraint on NULL column? |
---|---|
Author | Brad Pepers |
Post date | 2003-05-19T23:27:48Z |
On May 19, 2003 11:04 am, Dmitry Yemanov wrote:
can have a column with a unique constraint and multiple rows with NULL in
them right?
--
Brad Pepers
brad@...
> Gert,This is great and something I didn't realize had been changed in 1.5. So I
>
> > I have found that firebird does not allow an unique contsraint to be
> > defined on a NULLable column. This is a different behaviour to other
> > DBs. Will this be changed in firebird 1.5?
>
> It's already changed to conform the SQL200n specification, i.e. FB 1.5
> supports unique constraints for nullable columns.
can have a column with a unique constraint and multiple rows with NULL in
them right?
--
Brad Pepers
brad@...