Postgres Pro
Downloads
Home   >   mailing lists

index not used in ( varchar = text ) - Mailing list pgsql-admin

From Gaetano Mendola
Subject index not used in ( varchar = text )
Date
Msg-id b38dj6$ir$1@news.hub.org
Whole thread Raw
Responses Re: index not used in ( varchar = text )  (Will LaShell <will@lashell.net>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Björn Metzdorf
Date:
Subject: Re: problem: Postgresql and Unicode
Next
From: Robert Prather
Date:
Subject: PostgreSQL User On Mac OS X