how to return score/distance?

[pthieu]

I have a working SELECT statement using Drizzle ORM and pgvector-node:

const videos = await db
    .select({
      id: VideoTable.id,
      uid: VideoTable.uid,
      caption: VideoTable.caption,
    })
    .from(VideoTable)
    .where(eq(VideoTable.userId, userId))
    .orderBy(cosineDistance(VideoTable.embedding, embedding))
    .limit(10);

I would like to also return the similarity or distance score, how would I do this? Does pgvector-node offer a select operator?

[pthieu]

figured it out, was able to do this in the SELECT clause:

.select({
      id: VideoTable.id,
      uid: VideoTable.uid,
      caption: VideoTable.caption,
      distance: cosineDistance(VideoTable.embedding, embedding), // added this
    })