Let's say I have a table of stringlengths - sqlite>select * from stringlengths; length 4 1 9 ...
Can I create a view xstrings containing strings (for example of char 'x') with the lengths specified in stringlengths? desired result - sqlite>select * from xstrings; string xxxx x xxxxxxxx ... P.S I know that substr('xxxxxxxxx', 1, stringlengths.length) would work in this particular case but then I must know maximum value of stringlengths.length at the point of time when I construct the query. Is there a more flexible way? .. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users