Page 1 of 1

Implicit Casting by Vertica

Posted: Wed Aug 10, 2016 6:49 pm
by dubweezie
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.

Re: Implicit Casting by Vertica

Posted: Fri Aug 12, 2016 8:36 pm
by JimKnicely

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