How to apply like operator in pgvector for filtering

[deepak-hl]

        retriever = vector_store.as_retriever(
            search_kwargs={
                "k": 8,
                "filter": {
                    "$and": [
                        {"profile_names": {"$in": profile_names}},
                        {"date": date}
                    ]
                }
            }
        )

where 'profile_names': ['Arthur', 'Charlie']
i want to handle cases where the user inputs just the first name (e.g., "Arthur"), but i want it to match full names (like "Arthur Hayes") in the vector database through filtering

[dosubot[bot]]

To apply the $like operator in pgvector for filtering full names based on partial input, you can modify your filter to use the $like operator. Here's how you can adjust your code to handle cases where the user inputs just the first name:

retriever = vector_store.as_retriever(
    search_kwargs={
        "k": 8,
        "filter": {
            "$and": [
                {"profile_names": {"$in": profile_names}},
                {"date": date},
                {"full_name": {"$like": f"{profile_names[0]}%"}}
            ]
        }
    }
)

In this example, the $like operator is used to match any full name that starts with the given first name. The % character acts as a wildcard, allowing for partial matches. Adjust the field name ("full_name") to match the actual field in your vector store that contains the full names ^[1].

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}