EXEC SQL
    CREATE EXTENSION IF NOT EXISTS vector
END-EXEC.

EXEC SQL
    CREATE TABLE items (
        id bigserial PRIMARY KEY,
        embedding vector(3)
    )
END-EXEC.

MOVE "[1,2,3]" TO EMBEDDING.
MOVE "[4,5,6]" TO EMBEDDING2.
EXEC SQL
    INSERT INTO items (embedding)
        VALUES (:EMBEDDING), (:EMBEDDING2)
END-EXEC.

MOVE "[3,1,2]" TO EMBEDDING.
EXEC SQL
    SELECT id INTO :NEAREST-ID FROM items
        ORDER BY embedding <-> :EMBEDDING LIMIT 5
END-EXEC.