Re: [I] Proposal: Vector handling with extension(pgvector) [age]

[via GitHub]

mingfang commented on issue #1121:
URL: https://github.com/apache/age/issues/1121#issuecomment-2077987898

   First I have to create a function to effective do the `agtype` conversion
   ```sql
   CREATE OR REPLACE FUNCTION public.movies_view_bm25_search(search agtype) 
RETURNS agtype AS $$
        SELECT id::agtype
        FROM movies_view_bm25.search(search::text)
   $$ LANGUAGE sql;
   ```
   
   Then you can call the search from cypher
   ```cypher
   with public.movies_view_bm25_search('plot:drink') as it
   match (v1:MOVIE)
   where id(v1)=it
   return v1
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscr...@age.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org