Re: [sqlite] REGEXP parameter order - embarassed newbie

Hello James630165, I guess it depends on how good a programmer you are. I just used the web site and some reference books on SQL. Wrote my own wrapper and improve it as time goes on and I need new features. C Sunday, January 23, 2011, 8:05:08 PM, you wrote: Jac> JCC/DRH Jac> Jac> If a person

Re: [sqlite] REGEXP parameter order - embarassed newbie

Being one who speaks good English, has a logical mind, and has previously programmed in C, AND who had used SQLite for around five years on the strength of that, I still found the book useful when I read it a couple of months ago. I already knew the basics, but it shed light on a few obscure

Re: [sqlite] REGEXP parameter order

Hi Igor, >I'm not quite sure what you are talking about, but see the >documentation of like() and glob() functions here: You're right about LIKE and GLOB. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] REGEXP parameter order

Jean-Christophe Deschamps wrote: > Digging further I found mention of this only in the VTAB description, > but may be a mention or link to the infix argument reversal should > appear in the LIKE, GLOB, REGEXP, MATCH description, as implementing > simple extension functions doesn't

Re: [sqlite] REGEXP parameter order - embarassed newbie

JCC/DRH If a person speaks good English and has a logical mind, has previously programmed in C ... why is there a need to buy "The definitive guide to programming SQLite"? I understand that "Everyone does". Jim. ___ sqlite-users mailing list

Re: [sqlite] REGEXP parameter order

> > Sorry for elementary questions but when implementing a REGEXP function > > (I'm using PCRE from pcre.org) I need to know in which order the two > > arguments (target, pattern) will be passed to the function. > > > > I also would like to retain the last pattern used in compiled form > >

Re: [sqlite] REGEXP parameter order

On Sun, Jan 23, 2011 at 5:02 PM, Jean-Christophe Deschamps wrote: > Hi all, > > Sorry for elementary questions but when implementing a REGEXP function > (I'm using PCRE from pcre.org) I need to know in which order the two > arguments (target, pattern) will be passed to the

[sqlite] REGEXP parameter order

Hi all, Sorry for elementary questions but when implementing a REGEXP function (I'm using PCRE from pcre.org) I need to know in which order the two arguments (target, pattern) will be passed to the function. I also would like to retain the last pattern used in compiled form (connection-wise).