On 12/08/05, Fernando Vilas <[EMAIL PROTECTED]> 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
_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
