----- 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
