index not used in ( varchar = text )

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: index not used in ( varchar = text )
Date: 2003-02-22 17:55:52
Message-ID: b38dj6$ir$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all,

why in Postgresql 7.3.2 in a select like:

SELECT *
FROM user_login
WHERE login = 'FOO'::text;

and login is a VARCHAR the index on login
is not used anymore ?

Ciao
Gaetano

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Martin Guy 2003-02-23 02:27:34 Running postgresql/initdb on linux/parisc problem
Previous Message Laurette Cisneros 2003-02-22 16:42:26 Re: server won't shutdown