[mythtv] Predictive text input method

[Colin Guthrie]

Ashley Clark wrote:
> Yes, PostgreSQL does have a regexp search. You use the ~* operator to do 
> a case-insensitive match. So, for example, you'd use this similar SQL to 
> what was shown earlier.
> 
> SELECT DISTINCT title FROM program WHERE title ~* 
> '[2abc][5jkl][4ghi][2abc]';
> 
> It might also make sense to clamp that to the front of the string in the 
> regex for searching tv shows, or maybe have an option to switch between 
> unrestricted and start of phrase?

 From a UI point of view, the choice of "start of phrase" or 
"unrestricted" may be problematic, so that would make such an option an 
implementation specific choice (or user config option).

In an example Ian gave earlier in the thread he had a [0\s] at the 
begining to match a 0 or white space (not sure if the \s is the correct 
notation for My & PG, but that is fairly irrelevant!). That would allow 
you to match the start of a word very easily from a UI point of view - 
just press 0 first!!

If this syntax would also match the start of whole string, then the 
clamping may not be needed (though I appreciate this would return more 
results)?

I'm not sure if it would match the start of the whole string tho'... I 
guess it depends on how the database treats whitespace.

Col.


-- 

+------------------------+
|     Colin Guthrie      |
+------------------------+
|  myth at colin.guthr.ie   |
| http://colin.guthr.ie/ |
+------------------------+