Converting CHAR and VARCHAR to BINARY or VARBINARY
Sarah Lemaire, Manager, Vertica Documentation
August 16, 2018
Jim Knicely authored this tip. As of Vertica 9.1.1, explicit coercion (casting) from CHAR and VARCHAR data types to either BINARY or VARBINARY data types is supported! Prior to Vertica 9.1.1: dbadmin=> INSERT INTO test_coercion SELECT 'Convert me!'; OUTPUT -------- 1 (1 row) dbadmin=> SELECT c1::VARBINARY FROM test_coercion; ERROR 2366: Cannot cast type varchar to...