| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bhuvan A <bhuvansql(at)yahoo(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Strange Problem As Type Casting |
| Date: | 2001-11-03 16:01:02 |
| Message-ID: | 2205.1004803262@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Bhuvan A <bhuvansql(at)yahoo(dot)com> 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 for this table? The error is
not necessarily in the command you typed, it could be in subsidiary
processing.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Domingo Alvarez Duarte | 2001-11-03 18:16:55 | Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql |
| Previous Message | Edward Grabczewski | 2001-11-03 14:17:19 | Re: PL/pgSQL syntax for strings |