using pgvector with Kysely

Following the example here: https://github.com/pgvector/pgvector-node?darkschemeovr=1#kysely

But I get the error

ERROR: column "embedding" is of type vector but expression is of type character varying

ERROR: column "embedding" is of type vector but expression is of type character varying

ERROR: column "embedding" is of type vector but expression is of type character varying

ERROR: column "embedding" is of type vector but expression is of type character varying

Happy to provide code if necessary but there aren’t any differences from the tutorial

Using AWS RDS 13.12 (which has pgvector support)

GitHub

GitHub - pgvector/pgvector-node: pgvector support for Node.js and B...

pgvector support for Node.js and Bun (and TypeScript) - pgvector/pgvector-node

Solution

// Replace `string` with the type you have in the table interface.
sql<string>`${sql.ref(column)} <=> ${toSql(value)}::vector(3)`

// Replace `string` with the type you have in the table interface.
sql<string>`${sql.ref(column)} <=> ${toSql(value)}::vector(3)`

// Replace `string` with the type you have in the table interface.
sql<string>`${sql.ref(column)} <=> ${toSql(value)}::vector(3)`

// Replace `string` with the type you have in the table interface.
sql<string>`${sql.ref(column)} <=> ${toSql(value)}::vector(3)`

Jump to solution

using pgvector with Kysely

Similar Threads

Similar Threads

Similar Threads