On Sun, Aug 7, 2011 at 1:17 PM, Alexey Pechnikov <pechni...@mobigroup.ru>wrote:
> There are a lot of situations when is very useful to store list of > identifiers in table field. > The problem with the concept of "list as a string" is that it implies a specific token separator, and there is no single universal solution to that problem. As soon as someone implements the example you've shown, someone else will say, "but i have a semicolon-separated list..." Ad nauseum. Also keep in mind that sqlite3 tries, to a large degree, to be compatible with ANSI SQL, and (IN "A B C"), in the form you describe, is not ANSI-specified. -- ----- stephan beal http://wanderinghorse.net/home/stephan/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
