Valid input for boolean data type

Moderator: NorbertKrupa

Post Reply
User avatar
Josh
Intermediate
Intermediate
Posts: 106
Joined: Thu Jan 26, 2012 9:38 pm

Valid input for boolean data type

Post by Josh » Tue Oct 08, 2013 7:58 pm

Hi,

What are all the valid values that can be assigned to the boolean data type?

I've found that these work: 1, 0, t, f, true, false, 't', 'f', 'true' and 'false'.

Are there any others?

I want to make sure that data I am loading doesn't incorrectly set a boolean values to true or false if there is unexpected input data.
Thank you!
Joshua

Post Reply

Return to “Vertica SQL”