galaxy_ng
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_collection_ts_vector
Parameters
Name
Type
Mode
Definition
BEGIN NEW.search_vector := ( SELECT setweight(to_tsvector(coalesce(namespace,'')), 'A') || setweight(to_tsvector(coalesce(name, '')), 'A') || ( SELECT setweight(to_tsvector( coalesce(string_agg("ansible_tag"."name", ' '), '') ), 'B') FROM "ansible_tag" INNER JOIN "ansible_collectionversion_tags" ON ("ansible_tag"."pulp_id" = "ansible_collectionversion_tags"."tag_id") ) || ( SELECT setweight(to_tsvector( coalesce(string_agg(cvc ->> 'name', ' '), '') ), 'C') FROM jsonb_array_elements(cv.contents) AS cvc ) || setweight(to_tsvector(coalesce(description, '')), 'D') FROM ansible_collectionversion cv WHERE cv.content_ptr_id = NEW.content_ptr_id ); RETURN NEW; END;