diff options
| author | Yorhel <git@yorhel.nl> | 2021-11-24 11:06:28 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2021-11-24 11:06:28 +0100 |
| commit | 289d6c6fed1c71308e4ae8843bf9fda29dd62836 (patch) | |
| tree | d95e7491dcd5e0212027958fc6cca302e25668fb /util | |
| parent | 0df1ec1e68bdfa7e2b905eec06021e5666803e63 (diff) | |
Apply improved search to tags & traits as well
Diffstat (limited to 'util')
| -rw-r--r-- | util/updates/2021-11-24-tagtrait-search.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/util/updates/2021-11-24-tagtrait-search.sql b/util/updates/2021-11-24-tagtrait-search.sql new file mode 100644 index 00000000..7e4aaf50 --- /dev/null +++ b/util/updates/2021-11-24-tagtrait-search.sql @@ -0,0 +1,2 @@ +ALTER TABLE tags ADD COLUMN c_search text NOT NULL GENERATED ALWAYS AS (public.search_gen(ARRAY[name]::text[]||string_to_array(alias,E'\n'))) STORED; +ALTER TABLE traits ADD COLUMN c_search text NOT NULL GENERATED ALWAYS AS (public.search_gen(ARRAY[name]::text[]||string_to_array(alias,E'\n'))) STORED; |