Even if SQLite was already implementing a bigger subset of the array type of SQL2003 standard, your users would still have a few more words to learn :
'ROW', 'MEMBER OF', 'UNNEST' "C > 100 (match 158)" => " max(UNNEST(C)) > 100 " "C < 100 (match 42 and 76)" => " min(UNNEST(C)) < 100 " "C = 42 (match 42)" => "ROW(42) MEMBER OF C" (reference : to http://farrago.sourceforge.net/design/CollectionTypes.html) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
