VECTOR_SERIALIZE

VECTOR_SERIALIZE is synonymous with FROM_VECTOR.

Syntax

Description of the illustration vector_serialize.gif

Purpose

See FROM_VECTOR for semantics and examples.

Examples

SELECT VECTOR_SERIALIZE(VECTOR('[1.1,2.2,3.3]',3,FLOAT32));


VECTOR_SERIALIZE(VECTOR('[1.1,2.2,3.3]',3,FLOAT32))
--------------------------------------------------------------- [1.10000002E+000,2.20000005E+000,3.29999995E+000]

1 row selected.

SELECT VECTOR_SERIALIZE(VECTOR('[1.1, 2.2, 3.3]',3,FLOAT32) RETURNING VARCHAR2(1000));


VECTOR_SERIALIZE(VECTOR('[...]',3,FLOAT32)RETURNINGVARCHAR2(1000))
------------------------------------------------------------------ [1.10000002E+000,2.20000005E+000,3.29999995E+000]

1 row selected.

SELECT VECTOR_SERIALIZE(VECTOR('[1.1, 2.2, 3.3]',3,FLOAT32) RETURNING CLOB);


VECTOR_SERIALIZE(VECTOR('[1.1, 2.2, 3.3]',3,FLOAT32)RETURNINGCLOB)
-------------------------------------------------------- [1.10000002E+000,2.20000005E+000,3.29999995E+000]

1 row selected.

SELECT VECTOR_SERIALIZE(TO_VECTOR('[5,[2,4],[1.0,2.0]]', 5, FLOAT64, SPARSE) RETURNING CLOB FORMAT SPARSE);

VECTOR_SERIALIZE(TO_VECTOR('[5,[2,4],[1.0,2.0]]',5,FLOAT64,SPARSE)RETURNINGCLOBF
-------------------------------------------------------------------------------- [5,[2,4],[1.0E+000,2.0E+000]]

1 row selected.

SELECT VECTOR_SERIALIZE(TO_VECTOR('[5,[2,4],[1.0,2.0]]', 5, FLOAT64, SPARSE) RETURNING CLOB FORMAT DENSE);

VECTOR_SERIALIZE(TO_VECTOR('[5,[2,4],[1.0,2.0]]',5,FLOAT64,SPARSE)RETURNINGCLOBF
-------------------------------------------------------------------------------- [0,1.0E+000,0,2.0E+000,0]

1 row selected.