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

Commitcc5dc30

Browse files
authored
update docs (#1444)
1 parente17211a commitcc5dc30

File tree

1 file changed

+2
-23
lines changed

1 file changed

+2
-23
lines changed

‎pgml-cms/docs/api/sql-extension/pgml.decompose.md

Lines changed: 2 additions & 23 deletions
Original file line numberDiff line numberDiff line change
@@ -4,8 +4,7 @@ description: Decompose an input vector into it's principal components
44

55
#pgml.decompose()
66

7-
8-
Chunks are pieces of documents split using some specified splitter. This is typically done before embedding.
7+
Matrix decomposition reduces the number of dimensions in a vector, to improve relevance and reduce computation required.
98

109
##API
1110

@@ -21,30 +20,10 @@ pgml.decompose(
2120
| Parameter| Example| Description|
2221
|----------------|---------------------------------|----------------------------------------------------------|
2322
|`project_name`|`'My First PostgresML Project'`| The project name used to train models in`pgml.train()`.|
24-
|`vector`|`ARRAY[0.1, 0.45, 1.0]`| The feature vectorthat needs decomposition.|
23+
|`vector`|`ARRAY[0.1, 0.45, 1.0]`| The feature vectorto transform.|
2524

2625
##Example
2726

2827
```sql
2928
SELECTpgml.decompose('My PCA', ARRAY[0.1,2.0,5.0]);
3029
```
31-
32-
!!! example
33-
34-
```sql
35-
SELECT*,
36-
pgml.decompose(
37-
'Buy it Again',
38-
ARRAY[
39-
user.location_id,
40-
NOW()-user.created_at,
41-
user.total_purchases_in_dollars
42-
]
43-
)AS buying_score
44-
FROM users
45-
WHERE tenant_id=5
46-
ORDER BY buying_score
47-
LIMIT25;
48-
```
49-
50-
!!!

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp