On Fri, Jul 12, 2013 at 12:43:16PM +0530, techi eth scratched on the wall:
> I have query regarding accessing single & multidimensional array in SQLite3.
>
> Example: I have created table with (test [10] INTEGER, name [50] TEXT).
>
> How do I pass a value to insert each element of array?
>
> How do I read back? (I am using callback function for read back)
>
> Please cover answer by considering multidimensional array case as well.
Although the SQL99 and SQL2003 standard includes specs for an ARRAY
column type, SQLite does not support them.
As far as I'm aware, PostgreSQL is the only major database that
supports the ARRAY column type. Oracle has VARRAYs, which are very
similar, but the common wisdom seems to be that nested-tables are
better.
Arrays are a pretty specialized case. Most people deal with this type
of storage need by using a one-to-many relationship to another table.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it,
but showing it to the wrong people has the tendency to make them
feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
