You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 

3 lines
164 B

Note: text_pattern_ops index is needed for prefix LIKE to be guaranteed-fast
CREATE INDEX search_index ON items ((lower(data ->> 'name'::text)) text_pattern_ops);