You could use the UPPER function. Fortunately you're using PostgreSQL,
which conforms with much of the ANSI standard. UPPER and LOWER are
implementations of the fold functions required by ANSI SQL. This would be
the most standard way to solve your problem (with the notable exception of
support
im trying to do a case insensitive search in pgsql with a "WHERE blah
LIKE '%blah%'"
the problem is that currently if something contains Blah not just blah
it wont return that. suggestion? i know i can suck out every row and
then eregi them but that is majorly slow and inefficent . . .
Cameron
