Why would you want to cast that to text, if your field is a varchar? I wouldn't think you would have to cast it at all, or if you do, cast it to a varchar.
Curious, WIll On Sat, 2003-02-22 at 10:55, Gaetano Mendola wrote: > 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 > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
