Re: [sqlite] REGEXP parameter order - embarassed newbie

[Teg]

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 speaks good English and has a logical mind, has previously
Jac> programmed in C ... why is there a need to buy "The definitive guide to
Jac> programming SQLite"?
Jac>  
Jac> I understand that "Everyone does".
Jac>  
Jac> Jim.
Jac> ___
Jac> sqlite-users mailing list
Jac> sqlite-users@sqlite.org
Jac> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



-- 
Best regards,
 Tegmailto:t...@djii.com

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] REGEXP parameter order - embarassed newbie

[Duquette, William H (318K)]

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 areas for me.

Will


On 1/23/11 5:05 PM, "james630...@aol.com"  wrote:

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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

--
Will Duquette -- william.h.duque...@jpl.nasa.gov
Athena Development Lead -- Jet Propulsion Laboratory
"It's amazing what you can do with the right tools."

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] REGEXP parameter order

[Jean-Christophe Deschamps]

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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] REGEXP parameter order

[Igor Tandetnik]

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 imply immersion in VTAB stuff (IMVHO).

I'm not quite sure what you are talking about, but see the documentation of 
like() and glob() functions here:

http://www.sqlite.org/lang_corefunc.html

-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] REGEXP parameter order - embarassed newbie

[James630165]

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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] REGEXP parameter order

[Jean-Christophe Deschamps]

> > 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).  Is the use of sqlite3_get_auxdata possible in this
> > context as it is in overriding LIKE functions, for instance?
> >
>
>REGEXP works just like LIKE and GLOB.

Thanks Richard for this confirmation.

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 imply immersion in VTAB stuff (IMVHO).

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] REGEXP parameter order

[Richard Hipp]

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 function.
>
> I also would like to retain the last pattern used in compiled form
> (connection-wise).  Is the use of sqlite3_get_auxdata possible in this
> context as it is in overriding LIKE functions, for instance?
>

REGEXP works just like LIKE and GLOB.


>
> Thank you.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] REGEXP parameter order

[Jean-Christophe Deschamps]

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).  Is the use of sqlite3_get_auxdata possible in this 
context as it is in overriding LIKE functions, for instance?

Thank you.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users