The Vertica Database Forums

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.

Hi,

Are you trying to do this in vsql? If so, can you send some example code to help us figure out what is happening?

Thanks!