2009/7/6 Juan Pablo Cook <juamp...@gmail.com>: > Hi Everybody! > 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
SELECT * FROM employee WHERE name like 'h%'; --<<< there are not LIKE operator for integer values. you cannot use LIKE on integer columns regards Pavel > > 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
