Re: Informix pop quiz

On Fri, Oct 10, 2008 at 5:57 PM, Ian Michael Gumby <im_gumby@hotmail.com> wrote: > Bingo. > > And that was exactly my point. ;-) > > Seems a clown is too busy trying to master the business side of IBM to read > the initial question correctly. > > Here's the pop quiz question: > "> > > Do you know that informix allows a column to be declared as null > allowed > ^^^^^^^^^^^^^^^^^^^^^^^^ >> > > but at insert time does not allow null values to that column. Can >> > > anyone >> > > guess how is this possible? > " > > Like I said, one null record may exist. > Let me say it again: a column included in a primary key will not accept any row with a null value. A unique index will accept ONE null value. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...