PSQL Join

[Anon]

i have 2 table
user iccolor

---

name ic_code
ic_color ic_desc

My query:
SELECT name, ic_code FROM user, iccolor
WHERE user.ic_color = iccolor.ic_code AND user.name = 'test';

But it give me this error msg
Unable to identify an operator '=' for types 'character' and 'character varying'
You will have to retype this query using an explicit cast.

How am i suppose to cater this problem?

[Anon]

it seems that the 2 fields are of different type. You can recreate your tables and be sure to use the same database type for the columns
er.ic_color and iccolor.ic_code

[Anon]

Two answers. First, change your columns to type text (the preferred type according to the postgresql docs) and reload your data into it.

The easy way is to use select into like so:

select bid, bbalance, filler::text as filler into ttt from branches;

The above example pulls all the data from the branches table built by pgbench into a new table called ttt. The original type is character(88) the new one is text.

the other way is to force the coercion on the fly during the comparison:

SELECT name, ic_code FROM user, iccolor
WHERE user.ic_color::text = iccolor.ic_code::text AND user.name = 'test';