using pgvector with Kysely

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

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)`

Kysely•3y ago•

29 replies

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

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)`