Re: [sqlite] MATCH and ESCAPE

2014-02-12 Thread Attila
Dan provided the solution. Thanks! --- It's because by default the "[" character is treated as a punctuation or separator character and ignored. As a result the FTS query "[*" is equivalent to "" - which always returns zero rows. You can change the set of characters treated a punctuation by

Re: [sqlite] MATCH and ESCAPE

2014-02-12 Thread Richard Hipp
On Wed, Feb 12, 2014 at 4:57 AM, Attila 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 MATCH function using sqlite3_create_function(). -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] MATCH and ESCAPE

2014-02-12 Thread Attila
] MATCH and ESCAPE 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

Re: [sqlite] MATCH and ESCAPE

2014-02-12 Thread Richard Hipp
On Wed, Feb 12, 2014 at 4:17 AM, Attila wrote: > 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

Re: [sqlite] MATCH and ESCAPE

2014-02-12 Thread Hick Gunter
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] MATCH and ESCAPE Hello, Based on http://www.sqlite.org/lang_expr.html

[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 -- Attila @xyzones