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.