3/17/2024 0 Comments Remove tsearchOn the other hand – I’ve seen too many people that had their precious applications broken after upgrade. On one hand – removal of them didn’t touched me personally as i never did things like int = text. To be honest I don’t really have strong opinion on this. Oops, apparently it's not as obvious as it seemed earlier.īut, what should one do, if he has a ready software which works on 8.2, but he wants to upgrade to 8.3?įirst answer and the best way to solve the problem is: fix the code.Ĭheck which value should be cast to which, and add proper casts. What surprising? After all *I* can see that number “1" is equal to string “1", don't I ?įor example, try to answer, if “1" (integer) should be equal to these texts: Well, the standard answer is: “to avoid surprising behavior". It means that If You have anywhere join between tables that use fields of int (on one side) and text (on second side) fields to join – it will fail. You might need to add explicit type casts. HINT: No operator matches the given name and argument type (s ). ERROR: operator does not exist: integer = text
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |