pgvector.git / summary / log / commit / refs

commit    2e77650e1d5c612045c1b8549c8d1f8ebedded9d
Author:   Andrew Kane <andrew@ankane.org>
Date:     Mon Aug 01 05:34:03 2022 +0000

    Updated example [skip ci]


 README.md | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/README.md b/README.md
index 869d9524..d4a24246 100644
--- a/README.md
+++ b/README.md
@@ -130,6 +130,12 @@ Note: `tuples_done` and `tuples_total` are only populated during the `loading tu
 
 Consider [partial indexes](https://www.postgresql.org/docs/current/indexes-partial.html) for queries with a `WHERE` clause
 
+```sql
+SELECT * FROM table WHERE other_column = 123 ORDER BY column <-> '[3,1,2]' LIMIT 5;
+```
+
+can be indexed with:
+
 ```sql
 CREATE INDEX ON table USING ivfflat (column opclass) WHERE (other_column = 123);
 ```


[parent: 0a68b040fb14]