[sqlite] sqlite3 ltrim behaviour bug or feature?

Thanks Martin, Maybe the documentation could be extended: "The ltrim(X,Y) function returns a string formed by removing any and all characters that appear in Y from the left side of X. If the Y argument is omitted, ltrim(X) removes spaces from the left side of X. " to: "The ltrim(X,Y) function

Re: [sqlite] sqlite3 ltrim behaviour bug or feature?

Hi, this is the expected behaviour. See http://www.sqlite.org/lang_corefunc.html "The ltrim(X,Y) function returns a string formed by removing any and all characters that appear in Y from the left side of X. If the Y argument is omitted, ltrim(X) removes spaces from the left side of X. " The

[sqlite] sqlite3 ltrim behaviour bug or feature?

Hi, the following seems wrong to me: bash-4.0# sqlite3 SQLite version 3.6.14.2 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> select ltrim("12300567","1230"); 567 sqlite> select ltrim("012300567","0123"); 567 sqlite> select ltrim("12300567","123"); 00567