On 09/01/2016 09:34 AM, Viswanath wrote:
> Hi,
> Why is a citext column not using Btree index for like operation even without
> any wildcard character?
Because it doesn't know how.
> It can use Btree index if there is no wildcard character and if it is at the end right?
No; use pg_trgm for this.
> Also a text column is using index when there is no wildcard character,but it
> is also not using if it is present at the end.
Did you declare your index with text_pattern_ops?
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support