Implicit Casting by Vertica

Moderator: NorbertKrupa

Post Reply
dubweezie
Newbie
Newbie
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
JimKnicely
Site Admin
Site Admin
Posts: 1817
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Implicit Casting by Vertica

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

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!
Jim Knicely

Image

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”