Nacorid
d7bece250f
- Rewrite GetStyleProfile, FindSimilarUsers, UpsertStyleProfiles SQL queries to use @named parameters instead of positional placeholders - Regenerate sqlc Go files with meaningful parameter names - Update server.go and integration test to use new parameter field names - Fix Similarity int32→float64 type conversion
6 lines
No EOL
266 B
SQL
6 lines
No EOL
266 B
SQL
-- name: FindSimilarUsers :many
|
|
SELECT user_id, platform, embedding, top_keywords, style_summary, post_count,
|
|
1 - (embedding <=> @query_embedding::vector) AS similarity
|
|
FROM user_style_profiles
|
|
ORDER BY embedding <=> @query_embedding::vector
|
|
LIMIT @limit_val; |