RE: Informix pop quiz

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. But again, what do I know? -G > Subject: RE: Informix pop quiz> Date: Fri, 10 Oct 2008 11:43:32 -0500> From: JRPlugge@west.com> To: im_gumby@hotmail.com; informix-list@iiug.org> > No, not allowed. If you create it NULL ALLOWED and then put a UNIQUE CONSTRAINT it will allow 1 NULL value in, but no more.> > -----Original Message-----> From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Ian Michael Gumby> Sent: Friday, October 10, 2008 11:38 AM> To: informix-list@iiug.org> Subject: Re: Informix pop quiz> > On Oct 10, 11:03 am, Obnoxio The Clown <obno...@serendipita.com>> wrote:> > dcrunch...@aim.com wrote:> > > 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?> >> > PRIMARY KEY?> >> > (Just a guess, mind, I certainly couldn't be arsed to test it! :o)> >> > --> > Cheers,> > Obnoxio the Clown> >> > http://obotheclown.blogspot.com>; > Even still, I believe you can still have one null record in a primary> key constraint.> _______________________________________________> Informix-list mailing list> Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ See how Windows Mobile brings your life together—at home, work, or on the go. http://clk.atdmt.com/MRT/go/msnnkwxp1020093182mrt/direct/01/