Re: Casting problem

That was it! I re-defined the related columns and the problem
disappeared. :)

Thanks.

Tom Lane wrote:

> John Burski <John(dot)Burski(at)911ep(dot)com> writes:
>
>> clocker=# DELETE FROM employee_tbl WHERE emp_id = '1119';
>> ERROR: Unable to identify an operator '=' for types 'varchar' and 'bpchar'
>> You will have to retype this query using an explicit cast
>
>
> I'll bet you have a foreign-key constraint referencing this table,
> and the other column is varchar not char. 7.1 detects unexecutable
> FK constraints when you try to create one, but 7.0 didn't, IIRC.
>
> regards, tom lane
>
>

--
John Burski
I.T. Manager and Systems Administration
911 Emergency Products, Inc.
25 Sixth Avenue North
Saint Cloud, MN 56303
John(dot)Burski(at)911ep(dot)com

800-863-6911, extension 221
FAX: 800-863-2991
www.911ep.com