aboutsummaryrefslogtreecommitdiffhomepage
path: root/storage
diff options
context:
space:
mode:
Diffstat (limited to 'storage')
-rw-r--r--storage/entry.go6
1 files changed, 3 insertions, 3 deletions
diff --git a/storage/entry.go b/storage/entry.go
index ff081d4..5aa8b45 100644
--- a/storage/entry.go
+++ b/storage/entry.go
@@ -50,7 +50,7 @@ func (s *Storage) UpdateEntryContent(entry *model.Entry) error {
query := `
UPDATE entries
- SET document_vectors = to_tsvector(title || ' ' || coalesce(content, ''))
+ SET document_vectors = to_tsvector(substring(title || ' ' || coalesce(content, '') for 1000000))
WHERE id=$1 AND user_id=$2
`
_, err = tx.Exec(query, entry.ID, entry.UserID)
@@ -68,7 +68,7 @@ func (s *Storage) createEntry(entry *model.Entry) error {
INSERT INTO entries
(title, hash, url, comments_url, published_at, content, author, user_id, feed_id, document_vectors)
VALUES
- ($1, $2, $3, $4, $5, $6, $7, $8, $9, to_tsvector($1 || ' ' || coalesce($6, '')))
+ ($1, $2, $3, $4, $5, $6, $7, $8, $9, to_tsvector(substring($1 || ' ' || coalesce($6, '') for 1000000)))
RETURNING id, status
`
err := s.db.QueryRow(
@@ -107,7 +107,7 @@ func (s *Storage) updateEntry(entry *model.Entry) error {
query := `
UPDATE entries SET
title=$1, url=$2, comments_url=$3, content=$4, author=$5,
- document_vectors=to_tsvector($1 || ' ' || coalesce($4, ''))
+ document_vectors=to_tsvector(substring($1 || ' ' || coalesce($4, '') for 1000000))
WHERE user_id=$6 AND feed_id=$7 AND hash=$8
RETURNING id
`