6 lines
No EOL
230 B
SQL
6 lines
No EOL
230 B
SQL
-- name: FindSimilarUsers :many
|
|
SELECT user_id, platform, embedding, top_keywords, style_summary, post_count,
|
|
1 - (embedding <=> $1::vector) AS similarity
|
|
FROM user_style_profiles
|
|
ORDER BY embedding <=> $1::vector
|
|
LIMIT $2; |