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');
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
