RE: Changing Primary Index Question

Posted in 2003

Francisco Roldan — Wed, 3 Sep 2003 15:31:34 -0600 — source: Usenet: comp.databases.informix

But one row with a null value on one of its primary key fields doesn't make sense because of the primary key's definition. Regards -----Mensaje original----- De: Bill Hamilton [mailto:bham@finsco.com] Enviado el: Mi'rcoles, 03 de Septiembre de 2003 02:50 p.m. Para: John Carlson; informix-list@iiug.org Asunto: Re: Changing Primary Index Question With a single column index, you could have just one row that had a null in that column. With multiple columns, I believe you can have as many as you want, so long as the whole key is unique on each row. ----- Original Message ----- From: "John Carlson" <john_carlson@whsmithusa.com> To: <informix-list@iiug.org> Sent: Wednesday, September 03, 2003 1:24 PM Subject: Re: Changing Primary Index Question > As far as I know, the definition of a PK doesn't allow a nullable > column . . . . am I wrong? sending to informix-list sending to informix-list