Re: [sqlite] LIKE vs GLOB vs MATCH vs REGEXP

2015-01-16 Thread Scott Robison
On Jan 16, 2015 8:05 AM, "Simon Slavin" wrote: > > > On 16 Jan 2015, at 12:23pm, Jay Kreibich 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

Re: [sqlite] LIKE vs GLOB vs MATCH vs REGEXP

2015-01-16 Thread Simon Slavin
On 16 Jan 2015, at 12:23pm, Jay Kreibich 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.

Re: [sqlite] LIKE vs GLOB vs MATCH vs REGEXP

2015-01-16 Thread Jay Kreibich
On Jan 16, 2015, at 6:56 AM, Richard Hipp wrote: > On 1/16/15, Scott Robison wrote: >> LIKE & GLOB can be overridden with user defined functions. According to >> https://www.sqlite.org/lang_corefunc.html LIKE can be a 2 or 3 argument >> function, GLOB

Re: [sqlite] LIKE vs GLOB vs MATCH vs REGEXP

2015-01-16 Thread Scott Robison
On Fri, Jan 16, 2015 at 5:56 AM, Richard Hipp wrote: > On 1/16/15, Scott Robison wrote: > > LIKE & GLOB can be overridden with user defined functions. According to > > https://www.sqlite.org/lang_corefunc.html LIKE can be a 2 or 3 argument > > function,

Re: [sqlite] LIKE vs GLOB vs MATCH vs REGEXP

2015-01-16 Thread Richard Hipp
On 1/16/15, Scott Robison wrote: > So the only remaining question is whether there is any functional > difference between the LIKE & GLOB SQL functions and the same named > operators (other than argument order)? Is there a reason to prefer one or > the other in SQL

Re: [sqlite] LIKE vs GLOB vs MATCH vs REGEXP

2015-01-16 Thread Richard Hipp
On 1/16/15, Scott Robison wrote: > LIKE & GLOB can be overridden with user defined functions. According to > https://www.sqlite.org/lang_corefunc.html LIKE can be a 2 or 3 argument > function, GLOB can be a 2 argument function, and neither MATCH nor REGEXP > can be

Re: [sqlite] LIKE vs GLOB vs MATCH vs REGEXP

2015-01-16 Thread Scott Robison
On Fri, Jan 16, 2015 at 5:23 AM, Jay Kreibich wrote: > > On Jan 16, 2015, at 5:06 AM, Scott Robison > wrote: > > > LIKE & GLOB can be overridden with user defined functions. According to > > https://www.sqlite.org/lang_corefunc.html LIKE can be a 2 or 3

Re: [sqlite] LIKE vs GLOB vs MATCH vs REGEXP

2015-01-16 Thread Jay Kreibich
On Jan 16, 2015, at 5:06 AM, Scott Robison wrote: > LIKE & GLOB can be overridden with user defined functions. According to > https://www.sqlite.org/lang_corefunc.html LIKE can be a 2 or 3 argument > function, GLOB can be a 2 argument function, and neither MATCH nor