"Gaetano Mendola" <[EMAIL PROTECTED]> writes:
>> Why would you want to cast that to text, if your field is a varchar?
> 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.
So declare it as VARCHAR. Or cast it to varchar. You need to get rid
of the datatype ambiguity. "text = text" is a different operator from
"varchar = varchar".
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
