Re: [SQL] Strange Problem As Type Casting

2001-11-03 Thread Josh Berkus
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

Re: [SQL] Strange Problem As Type Casting

2001-11-03 Thread Tom Lane
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