ent
ent copied to clipboard
full text support for string list?
doesn't seem like it's possible. maybe we want it?
sql (14.7 (Homebrew))
Type "help" for help.
ola=# \d+ users
Table "public.users"
Column | Type | Collation | Nullable | Default | Storage | Compression | Stats target | Description
------------+--------+-----------+----------+---------+----------+-------------+--------------+-------------
first_name | text | | not null | | extended | | |
last_name | text | | not null | | extended | | |
emails | text[] | | not null | | extended | | |
Access method: heap
alter table users add column name_idx TSVECTOR GENERATED ALWAYS AS (to_tsvector('simple', coalesce(first_name, '') || ' ' || coalesce(last_name, '') || ' ' || array_to_string(emails, ' '::text))) STORED
;
ERROR: generation expression is not immutable
ola=#
https://dba.stackexchange.com/questions/162932/how-can-i-implement-full-text-search-on-a-single-value-in-a-text-column claims bad idea