On +May 30, Tom Lane wrote:
>
> SELECT uid INTO _uid FROM user_main WHERE username = _user::varchar;
>
> 7.4 will be more forgiving about text-versus-varchar discrepancies, but
> you can still get burnt by this problem on most other cross-datatype
> cases --- including char(n) versus varchar(n). Integer versus bigint
> is another common gotcha for newbies.
Thanks! Got me and that fixed it.
--
Tony Holmes
Founder and Senior Systems Architect
Crosswinds Internet Communications Inc.