Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit2d7a335

Browse files
committed
Fixed limit bug + added pypika
1 parentedc5cf5 commit2d7a335

File tree

3 files changed

+15
-3
lines changed

3 files changed

+15
-3
lines changed

‎pgml-sdks/python/pgml/pgml/collection.py‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -766,7 +766,6 @@ def vector_search(
766766
FROM {embeddings_table}
767767
CROSS JOIN query_cte
768768
ORDER BY score DESC
769-
LIMIT {top_k}
770769
)
771770
SELECT cte.score, chunks.chunk, documents.metadata
772771
FROM cte
@@ -777,7 +776,6 @@ def vector_search(
777776
query_text=query,
778777
model_params=sql.Literal(json.dumps(query_parameters)).as_string(conn),
779778
embeddings_table=embeddings_table,
780-
top_k=top_k,
781779
chunks_table=self.chunks_table,
782780
documents_table=self.documents_table,
783781
)
@@ -794,6 +792,8 @@ def vector_search(
794792
ifgeneric_filter:
795793
cte_select_statement+=" AND "+generic_filter
796794

795+
cte_select_statement+=" LIMIT {top_k}".format(top_k=top_k)
796+
797797
search_results=run_select_statement(
798798
conn,cte_select_statement,order_by="score",ascending=False
799799
)

‎pgml-sdks/python/pgml/poetry.lock‎

Lines changed: 12 additions & 1 deletion
Some generated files are not rendered by default. Learn more aboutcustomizing how changed files appear on GitHub.

‎pgml-sdks/python/pgml/pyproject.toml‎

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -20,6 +20,7 @@ langchain = "^0.0.167"
2020
ipywidgets ="^8.0.6"
2121
datasets ="^2.12.0"
2222
python-dotenv ="^1.0.0"
23+
pypika ="^0.48.9"
2324

2425

2526
[tool.poetry.group.dev.dependencies]

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp