You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
WITH query AS (
SELECT pgml.embed('distilbert-base-uncased', 'Star Wars christmas special is on Disney')::vector AS embedding
)
SELECT * FROM items, query ORDER BY items.embedding <-> query.embedding LIMIT 5;
Error message:
ERROR: relation "items" does not exist
Position: 152
SELECT * FROM items, query ORDER BY items.embedding <-> query.embedding LIMIT 5
^
1 statement failed.
But this SQL works (without index - index creation failed, this is another issue):
WITH query AS (
SELECT pgml.embed('distilbert-base-uncased', 'Star Wars christmas special is on Disney')::vector AS embedding
)
SELECT * FROM public.tweet_embeddings, query
ORDER BY
public.tweet_embeddings.embedding::vector <-> query.embedding
LIMIT 5;
The text was updated successfully, but these errors were encountered:
remote4me
changed the title
wrong SQL in readme
wrong SQL SELECT in readme
Mar 3, 2024
Environment: Ubuntu 22.04, Self-hosted Postgresml installed in Postgresql 13 database
I am following instructions here (under "Vector Database", "Step 3: Querying the index using embeddings for your queries"):
https://github.com/postgresml/postgresml?tab=readme-ov-file#vector-database
This SQL does not works:
Error message:
But this SQL works (without index - index creation failed, this is another issue):
The text was updated successfully, but these errors were encountered: