Informix pop quiz

Posted in 2008

dcruncher4@aim.com — 10 Oct 2008 08:26:39 -0700 — source: Usenet: comp.databases.informix

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?

↪ replying to dcruncher4@aim.com

Andrew Ford — Fri, 10 Oct 2008 10:48:58 -0500 — source: Usenet: comp.databases.informix

----- Original Message ----- From: <dcruncher4@aim.com> Newsgroups: comp.databases.informix To: <informix-list@iiug.org> Sent: Friday, October 10, 2008 10:26 AM Subject: Informix pop quiz > 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? > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list The column is part of a primary key constraint? Andrew

↪ replying to dcruncher4@aim.com

Madison Pruet — Fri, 10 Oct 2008 15:57:44 GMT — source: Usenet: comp.databases.informix

dcruncher4@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? > If you define a unique constraint on the column.