I'm asking you, because recently I have some problems with the LIKE so I test with an easy and simple query but doesn't work:
SELECT *
FROM employee
WHERE id like 'h%';
The error says:
"ERROR: operator does not exist: integer ~~ unknown
LINE 5: WHERE id like 'h%';
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
********** Error **********
ERROR: operator does not exist: integer ~~ unknown
SQL state: 42883
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Character: 34"
I don't know why because I did before more difficult querys and works well. What is the problem?
Thanks a lot
JP Cook
