Re: Is it possible to have an array in a table?

From: Serge Rielau <>
Date: Sun, 23 Aug 2009 09:05:38 -0400
Message-ID: <>


Generally you should use side tables with referential integrity to store such data.
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 Lab
Received on Sun Aug 23 2009 - 08:05:38 CDT

Original text of this message