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
Bhuvan A <[EMAIL PROTECTED]> writes:
> 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
Got any triggers, rules, or foreign keys fo