Re: multi-element array in table definition???

Posted in 1995

Kerry Sainsbury — Sat, 21 Jan 1995 00:24:53 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <3fm822$gl@cssun.mathcs.emory.edu>, jvemo@cyberspace.com (Jon C. Vemo) wrote: > Can I include a multi-element array as part of a table definition/create?? > For example, something like : array[13] of record (month, sum, amount) No you can't. One of the fundamental laws of normalising your database design is removal of repeating groups - guess what an array is? Create a seperate table with a seperate record for each month. If this table is for something like sales history or budgetting it makes your life MUCH easier when The Powers That Be decide to start holding 24 months or 5 years worth of data rather than 13 months. Makes the coding cleaner too. Performance may be an issue though :-( > I seem to recall seing a thread asking a similar question, but... Yes, *very* recently. --------------------------------------,------------------------------------- Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ Quanta Systems, Auckland, New Zealand | kcbbs.gen.nz:/informix/* | mathcs.emory.edu:/pub/informix/faq/* +64 9 377-4473 (work) 276-5546 (home) | quasar.ucar.edu:/?