Error passing query vector into Neon db

Sorry for a dumb question. It's my first time using PG / Neon so I apologize in advance.

I'm building a Next.js web app which allows semantic search of my PG database. I've successfully set up embeddings, which are type "vector" in Neon (using extension pgvector).

However, when I enter a query, something breaks once I send my SQL query from Javascript to PG. I know this because I can successfully hardcode my SQL query in Neon

Here's my code:
if (searchQuery) {
let searchEmbedding = await generate_embeddings(searchQuery);

let indexEmbedding = params.length + 1;
baseQuery =

SELECT * FROM db ORDER BY embedding <-> $${indexEmbedding}::vector LIMIT 15

SELECT * FROM db ORDER BY embedding <-> $${indexEmbedding}::vector LIMIT 15

;
params.push(searchEmbedding);
console.log("Updated SQL query:", baseQuery, "Params:", params)
}

The console log then returns this error:
error: 'malformed vector literal: "{"0.019361679","0.02858…65","0.017489731","0.0062273005","-0.013786826"}"

Here's another console log from my terminal:
Updated SQL query: SELECT * FROM portcos_test ORDER BY embedding <-> $1::vector LIMIT 15 Params: [
[
0.019361679, 0.028584778, 0.027478006, -0.01475696,
-0.007323825, -0.06602373, 0.02546942,
... etc..
]
]

I know the numbers aren't supposed to be strings. But I've been struggling to correctly cast them. Would really appreciate any help!

Neon•2y ago•

5 replies

standard-azure

Error passing query vector into Neon db

SELECT * FROM db ORDER BY embedding <-> $${indexEmbedding}::vector LIMIT 15

SELECT * FROM db ORDER BY embedding <-> $${indexEmbedding}::vector LIMIT 15

Error passing query vector into Neon db

Similar Threads

Error passing query vector into Neon db

Similar Threads

Similar Threads

Similar Threads