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.
Implicit Casting by Vertica
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Implicit Casting by Vertica
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!
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!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.