--
-- procedure ts2_to_tsvector/2
--
CREATE OR REPLACE FUNCTION ts2_to_tsvector (
ts2_cfg varchar,
ts2_txt varchar
) RETURNS varchar AS $$
DECLARE
ts2_result varchar;
BEGIN
perform set_curcfg(ts2_cfg);
select to_tsvector(ts2_cfg,ts2_txt) into ts2_result;
return ts2_result;
END;
$$ language plpgsql;
--
-- procedure ts2_to_tsquery/2
--
CREATE OR REPLACE FUNCTION ts2_to_tsquery (
ts2_cfg varchar,
ts2_txt varchar
) RETURNS tsquery AS $$
DECLARE
ts2_result tsquery;
BEGIN
perform set_curcfg(ts2_cfg);
select 1 into ts2_result;
select to_tsquery(ts2_cfg,ts2_txt) into ts2_result;
return ts2_result;
END;
$$ LANGUAGE plpgsql;