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
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.
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
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,
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
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
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
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
8 matches
Mail list logo