Howdy,
I'm try to do a search on users from one database against a table in another.
Both databases have a mixture of upper and lowercase characters. Is there a
way to tell postgres to consider a match if the absolute character is the
same regardless of case?
Ex
'ROB' should also produce a hit if postgres encouters 'rob'
Thanks,
-Rob