ent icon indicating copy to clipboard operation
ent copied to clipboard

full text support for string list?

Open lolopinto opened this issue 1 year ago • 0 comments

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

lolopinto avatar May 24 '23 00:05 lolopinto