Implicit Casting by Vertica

Moderator: NorbertKrupa

Post Reply
Posts: 1
Joined: Wed Aug 10, 2016 2:09 am

Implicit Casting by Vertica

Post by dubweezie » Wed Aug 10, 2016 6:49 pm

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.

User avatar
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am

Re: Implicit Casting by Vertica

Post by JimKnicely » Fri Aug 12, 2016 8:36 pm


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

Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “Vertica SQL”