text like index postgresql.sql

CREATE OR REPLACE FUNCTION documental.ferunaccent(text)
  RETURNS text AS
$BODY$
    SELECT unaccent($1);
$BODY$
  LANGUAGE sql IMMUTABLE
  COST 100;
 
 
-- GIST:
CREATE INDEX docmdvalor_txtidxbtree ON documental.doc_md_valor
USING gist ( (lower(documental.ferunaccent(valor_text))) gist_trgm_ops )
WHERE valor_text IS NOT NULL ;
 
 
-- GIN:
CREATE INDEX docmdvalor_vchargin
 ON documental.doc_md_valor
 USING gin
 (lower(documental.ferunaccent(valor_varchar::text)) COLLATE pg_catalog."default" gin_trgm_ops)
 WHERE valor_varchar IS NOT NULL;