Can you specify SearchVector weights with UpdateSearchVector?

[mrcoles]

Is there a way to specify SearchVector weights with UpdateSearchVector? IDK if GistIndex also comes into play here instead of GinIndex?

import pgtrigger
from django.contrib.postgres.indexes import GinIndex
from django.contrib.postgres.search import SearchVector, SearchVectorField
from django.db import models

# example configuration of a model
class Items(models.Model):
    name = models.CharField(_("name"), max_length=100, db_index=True)
    description = models.CharField(_("description"), max_length=500, default="", blank=True)
    search_vector = SearchVectorField(null=True)

    class Meta:
        indexes = (GinIndex(fields=["search_vector"]),)
        triggers = [
            pgtrigger.UpdateSearchVector(
                name="add_name_desc_to_vector",
                vector_field="search_vector",
                document_fields=["name", "description"],
            ),
        ]

# example update by hand
Exercise.objects.update(
    search_vector=(
        SearchVector('name', weight='A') +
        SearchVector('description', weight='B')
    )
)

[wesleykendall]

pgtrigger is calling Postgres's tsvector_update_trigger utility function. This function does not seem to support adding weights to each column to the best of my knowledge.

If you want to sync a vector with weighted fields, your best bet for now is to write a custom trigger to do that