[mythtv] Database helper functions and pgsql support

[Nezar Nielsen]

On 8/13/05, Robert Johnston <anaerin at gmail.com> wrote:
> 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%'))

If you want to do a case-insensitive LIKE in pgsql, you just go:

SELECT field FROM table WHERE column ilike '%sEaRcH%'


Also, if you want to do bulk-inserts, use:

COPY table (id, column) FROM stdin;
1	firstrow
2	secondrow
3	thirdrow
\.



-- 
Mvh. Nezar Nielsen
http://fez.dk