Re: [sqlite] MATCH and ESCAPE

2014-02-12 Thread Attila
uot;); --- On 2014-02-12 11:05, Richard Hipp wrote: On Wed, Feb 12, 2014 at 4:57 AM, Attila <dex...@xyzones.org> wrote: I tried that one as well. SQLite has no built-in MATCH function. If you want to use the MATCH syntax, then you need to register your own MA

Re: [sqlite] MATCH and ESCAPE

2014-02-12 Thread Attila
I tried that one as well. On 2014-02-12 10:26, Hick Gunter wrote: Maybe you should be using single quotes as string delimiters? -Ursprüngliche Nachricht- Von: Attila [mailto:dex...@xyzones.org] Gesendet: Mittwoch, 12. Februar 2014 10:18 An: sqlite-users@sqlite.org Betreff: [sqlite

[sqlite] MATCH and ESCAPE

2014-02-12 Thread Attila
Hello, Based on http://www.sqlite.org/lang_expr.html#match first diagram i would expect that MATCH "\[*" ESCAPE "\" to work. Actually it return Error: wrong number of arguments to function MATCH() Could you please advise? Thanks, Attila