postgres json --> array --> pgvector

log

postgres=# CREATE TABLE x AS SELECT '{"foo": 1, "bar": 2}'::jsonb AS payload;
SELECT 1

postgres=# SELECT * FROM x;
       payload
----------------------
 {"bar": 2, "foo": 1}
(1 row)

postgres=# SELECT ARRAY[payload->'foo', payload->'bar']::float[]::vector FROM x;
 array 
-------
 [1,2]
(1 row)