It is using index here , it is just that performance i.e query that use
functional index (one with lower) is performing better then index created on
citext column.
Deepak
On Sunday, April 8, 2018, 3:13:26 AM PDT, Nandakumar M
wrote:
Hi,
I have also faced the same problem with citext
Hi,
I have also faced the same problem with citext extension. It does not
use index when thereby making it almost unusable. The problem has to
do with how collation is handled from what I have read in old threads
in postgres mailing list (please refer
https://dba.stackexchange.com/questions/105244
