pgvector.git / summary / log / commit / refs
commit f361bf27048eae3095d04107ba7ebcb221dddda0
Author: Andrew Kane <andrew@ankane.org>
Date: Fri Nov 03 23:42:14 2023 +0000
Improved docs on indexing vectors with different dimensions [skip ci]
README.md | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/README.md b/README.md
index 86a074d5..a44aa0e8 100644
--- a/README.md
+++ b/README.md
@@ -413,7 +413,7 @@ You’ll need to use [dimensionality reduction](https://en.wikipedia.org/wiki/Di
#### Can I store vectors with different dimensions in the same column?
-You can use the `vector` type (instead of `vector(3)`). However, to index the column, you’ll need to use an [expression](https://www.postgresql.org/docs/current/indexes-expressional.html) to set the number of dimensions and a partial index to filter rows with different dimensions.
+You can use the `vector` type (instead of `vector(3)`). However, you can only create indexes on rows with the same number of dimensions (using [partial indexing](https://www.postgresql.org/docs/current/indexes-partial.html) on an [expression](https://www.postgresql.org/docs/current/indexes-expressional.html)).
```sql
CREATE INDEX ON items USING hnsw ((embedding::vector(3)) vector_l2_ops) WHERE (model_id = 123);
[parent: 3d8c1921aadd]