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
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
] 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
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
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
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
6 matches
Mail list logo