Re: Strange Problem As Type Casting

Bhuvanm

> test=> UPDATE users set user_id=1 ,login_id='admin' where
> user_id='1346';
> ERROR:  Unable to identify an operator '=' for types 'text' and
> 'int4'
>         You will have to retype this query using an explicit cast

Stop quoting your integers.  It should be 
WHERE user_id = 1346

No quotes for numbers.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco