Re: [sqlite] instr function or equivalent

2012-09-10 Thread kball...@kennethballard.com
Here's one that I wrote a while back: void sqlite3_instr(sqlite3_context* pContext, int argc, sqlite3_value** argv) { const char *str1 = (const char *) sqlite3_value_text(argv[0]); const char *str2 = (const char *) sqlite3_value_text(argv[1]); char *p = strstr(str1, str2); int nRe

Re: [sqlite] SQLite 3.7.6 and 3.7.6.1 -- Performance issue with Triggers

2011-04-21 Thread kball...@kennethballard.com
011 at 5:35 PM, Kenneth Ballard < > kball...@kennethballard.com> wrote: > > > Good afternoon, > > > > Here is an issue I started to experience after upgrading from SQLite > > 3.7.5 to 3.7.6 involving a trigger I have on a database table. > > > > Using the dat