From 0a98d9df12cfc6ea73729b0b3feb3fee52c9f336 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Fri, 19 Nov 2021 13:33:19 +0100 Subject: Search adjustments + use new search for producers,staff,characters too --- util/updates/2021-11-19-more-search.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 util/updates/2021-11-19-more-search.sql (limited to 'util') diff --git a/util/updates/2021-11-19-more-search.sql b/util/updates/2021-11-19-more-search.sql new file mode 100644 index 00000000..5b6a99b0 --- /dev/null +++ b/util/updates/2021-11-19-more-search.sql @@ -0,0 +1,9 @@ +BEGIN; +\i sql/func.sql +ALTER TABLE releases DROP COLUMN c_search; +DROP FUNCTION search_gen(boolean,text[]); +ALTER TABLE releases ADD COLUMN c_search text NOT NULL GENERATED ALWAYS AS (public.search_gen(ARRAY[title, original])) STORED; +ALTER TABLE producers ADD COLUMN c_search text NOT NULL GENERATED ALWAYS AS (public.search_gen(ARRAY[name, original]::text[]||string_to_array(alias,E'\n'))) STORED; +ALTER TABLE chars ADD COLUMN c_search text NOT NULL GENERATED ALWAYS AS (public.search_gen(ARRAY[name, original]::text[]||string_to_array(alias,E'\n'))) STORED; +ALTER TABLE staff_alias ADD COLUMN c_search text NOT NULL GENERATED ALWAYS AS (public.search_gen(ARRAY[name, original])) STORED; +COMMIT; -- cgit v1.2.3