hi all,
i am using postgresql 7.1.
here i am facing some strange problem for last 2 days.
i have a table 'users' as below
test=> \d users
Table "users"
Attribute | Type | Modifier
---+
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