On 16 Jan 2015, at 12:23pm, Jay Kreibich <j...@kreibi.ch> wrote: > They can all be (re)defined, some just happen to have default functions: > > https://www.sqlite.org/lang_expr.html#like
Might be worth noting here that there can be a danger in replacing the definitions of default functions. These functions might be used in your schema (e.g. for CHECK constraints) and may be overridden in your program before it handles data. Someone could then open the same database in another program (e.g. the Shell Tool) which had instead the default functions and use that to add data. If instead you define custom functions and use those in your schema, if someone opens your database in another program it will have no definition for the function, and produce an error. I'm not saying that overriding functions is always bad, just reminding people of the danger. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users