Answer the question
In order to leave comments, you need to log in
Why is the simplest select query not being executed?
Greetings! I started to study postgresql and I don’t understand why the request to select rows by id with serial data type does not work. The request looks like this: select * from table where id like '133%'
At the same time, pgAdmin throws an error:
ERROR: operator does not exist: integer ~~ unknown
SQL status: 42883
Hint: An operator with the given name and argument types could not be found. Perhaps you should add explicit type conversions.
Symbol: 29
Answer the question
In order to leave comments, you need to log in
Perhaps you should add explicit type conversions.You are trying to work with a number ( id ) like a string ( like ). Cast a number to a string and it will work.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question