Hey everyone, I'm having an issue with implicit casting. Essentially what is happening is that I have two variables that I am trying explicitly cast as VARCHAR because they are a combination of integers and letters. However, whenever I try to create the particular table I am working on Vertica implicitly casts those variables as "float8."
My question is if there is any way to turn off implicit casting so that I can keep those variables as VARCHAR? I know that explicit casting should override implicit but it's not happening.
Any help is appreciated.
2 posts • Page 1 of 1