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

----- Original Message -----
From: "Will LaShell" <will@lashell.net>
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