my boss (who is -not- an rdba) wants to have tables that store cartesian type coordinates, and he wants those coordinates to be stored in one column.
i.e. column "coordinate" with (i,j,k) or for example (10,20,30) or (5.25,1.34,8.456)
instead of what i'd naturally think to do with three columns, column "i" column "j" and column "k" with the three parts of the cartesian coordinate.
i'm hesitant to use a comma separated value string in the column (to implode and explode with a programming language like PHP) because... i want DB2 to see the numerical data as numerical data, so i can order rows correctly and find a range of values from the table (i.e. say i want to get all of the rows where coordinate 'i' is > 200 and < 500)
is it possible to write an array like this to a column in a DB2 table? if not it's ok, i just would rather not have to be the one to explain to my boss that it's not a possibility :-0 !