Re: [HACKERS] MySQL search query is not executing in Postgres DB

Hi, Thanks for the reply. It is not possible to change the query in our environment. So we need to do casting. I'm a new bee, so it will be more helpful if you give me some simple examples. -- View this message in context: http://postgresql.1045698.n5.nabble.com/MySQL-search-query-is-not-executi

[HACKERS] MySQL search query is not executing in Postgres DB

In MySQL the below query is executing properly. SELECT * FROM WHERE (Table.ID LIKE '1%') But when i try to execute the above query in Postgres, i get the following Exception "org.postgresql.util.PSQLException: ERROR: operator does not exist: integer ~~ unknown Hint: No operator matches the given