Re: Is it possible to have an array in a table?
Date: Sun, 23 Aug 2009 09:05:38 -0400
Generally you should use side tables with referential integrity to store
Let's use your phone number example.
It is trivial for the DBMS to reverse lookup a name from a phone number if the data is stored in relational format: (empid, number) If you store your phone-numbers in an array there will be no indexing, no statistics, no detection of duplicate numbers.
ARRAYs belong into the world of procedural logic, not relational, IMHO
-- Serge Rielau SQL Architect DB2 for LUW IBM Toronto LabReceived on Sun Aug 23 2009 - 08:05:38 CDT