Hi, Why is a citext column not using Btree index for like operation even without any wildcard character? It can use Btree index if there is no wildcard character and if it is at the end right? 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. -- View this message in context: http://postgresql.nabble.com/Text-Citext-column-and-Btree-index-tp5918823.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
