Thanks for your response. I think your question is my point i.e. indeed...which one do you keep? It's a little ambiguous isn't it? I suppose it makes most sense to return back to the data BEFORE you added the yy dimension which result in returning to... xid yid data 1 1 3 2 1 4 1 2 5 2 2 6
So to "remove" the dimension you just seem to need to reduce it's elements to ONE otherwise you'd be removing all data. An explanation of multidimensional arrays explained that the elements of each new dimension held an array in itself. If they were separate arrays they'd be fairly easy to get rid of. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users