diff options
Diffstat (limited to 'storage')
| -rw-r--r-- | storage/entry.go | 6 |
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 ` |