Re: Make a column case insensitive

On Fri, 2004-08-06 at 11:29, Gordon Ross wrote:
> Is it possible to make a column case insensitive, without having to pepper your SELECTs with lots of lower() function
calls(and forgetting to do it at times !)
 

You could make yourself a set returning function to do this job -- but
that is probably just as difficult to remember when selecting data out
of the table.

create function abc(text) returns set of tab as 'select * from tab where
col = lower($1);' language sql;

select * from abc('sEaRcH_VaLuE');