[mythtv] Database helper functions and pgsql support

Robert Johnston anaerin at gmail.com
Sat Aug 13 00:13:43 UTC 2005


On 12/08/05, Fernando Vilas <fvilas at iname.com> wrote:
> I'm sure more issues will be seen, but the above are relatively minor.  If you choose to use Postgres, a simple dump and restore from a MySQL database will not work, so you'll be starting over in Postgres.  Also, remember that Postgres has case-sensitive strings, where MySQL does not, so capitalization of keywords during searches is important.

Is it not possible, during searches, to do "UPPER()"'s on both Search
terms and the field they're searching on, to make them case
insensitive again. So, for example:

SELECT program_name, description WHERE (UPPER(program_name) LIKE
UPPER('%Search String%')) OR (UPPER(description) LIKE UPPER('%Search
String%'))

Or is that not possible in Postgres?
-- 
Robert "Anaerin" Johnston


More information about the mythtv-dev mailing list