Postgres Pro
Downloads
Home   >   mailing lists

Text,Citext column and Btree index - Mailing list pgsql-general

From Viswanath
Subject Text,Citext column and Btree index
Date
Msg-id 1472715296138-5918823.post@n3.nabble.com
Whole thread Raw
Responses Re: Text,Citext column and Btree index  (Vik Fearing <vik@2ndquadrant.fr>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Gary Evans
Date:
Subject: Re: Vacuum Full - Questions
Next
From: Vik Fearing
Date:
Subject: Re: Text,Citext column and Btree index