----- Original Message ----- From: "Will LaShell" <[EMAIL PROTECTED]> Newsgroups: comp.databases.postgresql.admin Sent: Sunday, February 23, 2003 7:02 PM Subject: Re: index not used in ( varchar = text )
> 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 Of course that example was a semplification of a real situation: .......... my_login ALIAS FOR $1; SELECT * FROM user_login WHERE login = my_login; .................. and $1 is of type TEXT. I had the same function on Postgres 7.2.3 and was working correctly. Ciao Gaetano ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
