PostgreSQL is case sensitive. To do what you want create a function index. So say
CREATE UNIQUE INDEX test_upper_idx ON mytable (UPPER(myfield));
That way when you use UPPER(myfield)
in your query the index will be used.
See this link
PostgreSQL is case sensitive. To do what you want create a function index. So say
CREATE UNIQUE INDEX test_upper_idx ON mytable (UPPER(myfield));
That way when you use UPPER(myfield)
in your query the index will be used.
See this link