Add support to "vector_dims" when using sqlalchemy ORM about pgvector-python

[ostefano]

A workaround (which might be enough) seems to be adding a clause using where(text("vector_dims(field) = ${vector_len of the queried term}"))

[ankane]

Hi @ostefano, thanks for the suggestion. Can you share more details about the specific use case? Typically, vectors with different dimensions will come from different models, so you'll want another field like model_id on the table to use for filtering instead (since even if two models have the same number of dimensions, you don't want to compare embeddings across models).

[ostefano]

Hi @ankane indeed you are right, that shall not be needed. However it is counterintuitive from a DB perspective that the select would stop working, and there is not much documentation about it. Happy to close it, but I would mention this aspect more prominently.