PGError: ERROR: operator does not exist: character = integer

rubyonrails-talk
1

Hi,

I'm using PostgreSql database with the rails application,In a functionality I'm trying to compare two attributes in a condition, one is of type varchar and other the Integer. While doing so i'm getting the error as below.

ActiveRecord::StatementInvalid: PGError: ERROR: operator does not exist: character = integer

LINE 5: WHERE PART.part_number = UNIT.part_number::INT                                         ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

I can't change the data type of the columns but I need to compare the above condition. Can anyone help me out in solving the above.

Thanks in advance.

2

Uh, did you try following that hint? If it didn't really register you might try googling `postgres type cast` :slight_smile:

HTH,