Re: Indexes in PL/SQL

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.