File Manager

Hackfut Security File Manager

Current Path: /opt/td-agent/embedded/share/postgresql/extension

opt / td-agent / embedded / share / postgresql / extension /

📁 ..
📄 adminpack--1.0--1.1.sql(274 B)
📄 adminpack--1.0.sql(1.5 KB)
📄 adminpack--1.1.sql(1.57 KB)
📄 adminpack.control(176 B)
📄 autoinc--1.0.sql(249 B)
📄 autoinc--unpackaged--1.0.sql(250 B)
📄 autoinc.control(149 B)
📄 bloom--1.0.sql(666 B)
📄 bloom.control(156 B)
📄 btree_gin--1.0.sql(24.24 KB)
📄 btree_gin--unpackaged--1.0.sql(9.87 KB)
📄 btree_gin.control(160 B)
📄 btree_gist--1.0--1.1.sql(3.65 KB)
📄 btree_gist--1.1--1.2.sql(4.24 KB)
📄 btree_gist--1.2.sql(40.15 KB)
📄 btree_gist--unpackaged--1.0.sql(20.98 KB)
📄 btree_gist.control(163 B)
📄 chkpass--1.0.sql(1.33 KB)
📄 chkpass--unpackaged--1.0.sql(635 B)
📄 chkpass.control(150 B)
📄 citext--1.0--1.1.sql(1 KB)
📄 citext--1.1--1.2.sql(2.68 KB)
📄 citext--1.2--1.3.sql(307 B)
📄 citext--1.3.sql(12.69 KB)
📄 citext--unpackaged--1.0.sql(9.55 KB)
📄 citext.control(158 B)
📄 cube--1.0--1.1.sql(1.56 KB)
📄 cube--1.1--1.2.sql(3.16 KB)
📄 cube--1.2.sql(9.53 KB)
📄 cube--unpackaged--1.0.sql(3.12 KB)
📄 cube.control(142 B)
📄 dblink--1.0--1.1.sql(419 B)
📄 dblink--1.1--1.2.sql(2.77 KB)
📄 dblink--1.2.sql(6.49 KB)
📄 dblink--unpackaged--1.0.sql(2.8 KB)
📄 dblink.control(170 B)
📄 dict_int--1.0.sql(711 B)
📄 dict_int--unpackaged--1.0.sql(493 B)
📄 dict_int.control(158 B)
📄 dict_xsyn--1.0.sql(694 B)
📄 dict_xsyn--unpackaged--1.0.sql(488 B)
📄 dict_xsyn.control(179 B)
📄 earthdistance--1.0--1.1.sql(671 B)
📄 earthdistance--1.1.sql(3.15 KB)
📄 earthdistance--unpackaged--1.0.sql(959 B)
📄 earthdistance.control(202 B)
📄 file_fdw--1.0.sql(475 B)
📄 file_fdw.control(155 B)
📄 fuzzystrmatch--1.0--1.1.sql(788 B)
📄 fuzzystrmatch--1.1.sql(1.54 KB)
📄 fuzzystrmatch--unpackaged--1.0.sql(1.08 KB)
📄 fuzzystrmatch.control(175 B)
📄 hstore--1.0--1.1.sql(279 B)
📄 hstore--1.1--1.2.sql(1.17 KB)
📄 hstore--1.2--1.3.sql(525 B)
📄 hstore--1.3--1.4.sql(4.58 KB)
📄 hstore--1.4.sql(13.44 KB)
📄 hstore--unpackaged--1.0.sql(5.38 KB)
📄 hstore.control(158 B)
📄 insert_username--1.0.sql(273 B)
📄 insert_username--unpackaged--1.0.sql(282 B)
📄 insert_username.control(170 B)
📄 intagg--1.0--1.1.sql(471 B)
📄 intagg--1.1.sql(1.06 KB)
📄 intagg--unpackaged--1.0.sql(468 B)
📄 intagg.control(119 B)
📄 intarray--1.0--1.1.sql(1.75 KB)
📄 intarray--1.1--1.2.sql(4.81 KB)
📄 intarray--1.2.sql(12 KB)
📄 intarray--unpackaged--1.0.sql(6.61 KB)
📄 intarray.control(176 B)
📄 isn--1.0--1.1.sql(12.04 KB)
📄 isn--1.1.sql(68.25 KB)
📄 isn--unpackaged--1.0.sql(23.15 KB)
📄 isn.control(160 B)
📄 lo--1.0--1.1.sql(223 B)
📄 lo--1.1.sql(722 B)
📄 lo--unpackaged--1.0.sql(314 B)
📄 lo.control(126 B)
📄 ltree--1.0--1.1.sql(5.55 KB)
📄 ltree--1.1.sql(18.92 KB)
📄 ltree--unpackaged--1.0.sql(7.81 KB)
📄 ltree.control(155 B)
📄 moddatetime--1.0.sql(261 B)
📄 moddatetime--unpackaged--1.0.sql(266 B)
📄 moddatetime.control(165 B)
📄 pageinspect--1.0--1.1.sql(560 B)
📄 pageinspect--1.1--1.2.sql(562 B)
📄 pageinspect--1.2--1.3.sql(1.9 KB)
📄 pageinspect--1.3--1.4.sql(2.51 KB)
📄 pageinspect--1.4--1.5.sql(1.32 KB)
📄 pageinspect--1.5.sql(6.12 KB)
📄 pageinspect--unpackaged--1.0.sql(1.09 KB)
📄 pageinspect.control(173 B)
📄 pg_buffercache--1.0--1.1.sql(508 B)
📄 pg_buffercache--1.1--1.2.sql(271 B)
📄 pg_buffercache--1.2.sql(794 B)
📄 pg_buffercache--unpackaged--1.0.sql(351 B)
📄 pg_buffercache.control(157 B)
📄 pg_freespacemap--1.0--1.1.sql(335 B)
📄 pg_freespacemap--1.1.sql(899 B)
📄 pg_freespacemap--unpackaged--1.0.sql(375 B)
📄 pg_freespacemap.control(160 B)
📄 pg_prewarm--1.0--1.1.sql(281 B)
📄 pg_prewarm--1.1.sql(475 B)
📄 pg_prewarm.control(139 B)
📄 pg_stat_statements--1.0--1.1.sql(1.22 KB)
📄 pg_stat_statements--1.1--1.2.sql(1.3 KB)
📄 pg_stat_statements--1.2--1.3.sql(1.42 KB)
📄 pg_stat_statements--1.3--1.4.sql(345 B)
📄 pg_stat_statements--1.4.sql(1.39 KB)
📄 pg_stat_statements--unpackaged--1.0.sql(449 B)
📄 pg_stat_statements.control(191 B)
📄 pg_trgm--1.0--1.1.sql(536 B)
📄 pg_trgm--1.1--1.2.sql(2.14 KB)
📄 pg_trgm--1.2--1.3.sql(2.83 KB)
📄 pg_trgm--1.3.sql(7.79 KB)
📄 pg_trgm--unpackaged--1.0.sql(4.15 KB)
📄 pg_trgm.control(177 B)
📄 pg_visibility--1.0--1.1.sql(883 B)
📄 pg_visibility--1.1.sql(2.76 KB)
📄 pg_visibility.control(186 B)
📄 pgcrypto--1.0--1.1.sql(307 B)
📄 pgcrypto--1.1--1.2.sql(483 B)
📄 pgcrypto--1.2--1.3.sql(2.29 KB)
📄 pgcrypto--1.3.sql(5.57 KB)
📄 pgcrypto--unpackaged--1.0.sql(2.39 KB)
📄 pgcrypto.control(137 B)
📄 pgrowlocks--1.0--1.1.sql(651 B)
📄 pgrowlocks--1.1--1.2.sql(253 B)
📄 pgrowlocks--1.2.sql(555 B)
📄 pgrowlocks--unpackaged--1.0.sql(273 B)
📄 pgrowlocks.control(152 B)
📄 pgstattuple--1.0--1.1.sql(400 B)
📄 pgstattuple--1.1--1.2.sql(1.4 KB)
📄 pgstattuple--1.2--1.3.sql(1.1 KB)
📄 pgstattuple--1.3--1.4.sql(623 B)
📄 pgstattuple--1.4.sql(3.68 KB)
📄 pgstattuple--unpackaged--1.0.sql(457 B)
📄 pgstattuple.control(147 B)
📄 plpgsql--1.0.sql(332 B)
📄 plpgsql--unpackaged--1.0.sql(381 B)
📄 plpgsql.control(179 B)
📄 postgres_fdw--1.0.sql(507 B)
📄 postgres_fdw.control(172 B)
📄 refint--1.0.sql(343 B)
📄 refint--unpackaged--1.0.sql(314 B)
📄 refint.control(169 B)
📄 seg--1.0--1.1.sql(2.38 KB)
📄 seg--1.1.sql(7.95 KB)
📄 seg--unpackaged--1.0.sql(2.72 KB)
📄 seg.control(172 B)
📄 sslinfo--1.0--1.1.sql(375 B)
📄 sslinfo--1.1--1.2.sql(746 B)
📄 sslinfo--1.2.sql(1.5 KB)
📄 sslinfo--unpackaged--1.0.sql(846 B)
📄 sslinfo.control(146 B)
📄 tablefunc--1.0.sql(2.1 KB)
📄 tablefunc--unpackaged--1.0.sql(1.13 KB)
📄 tablefunc.control(174 B)
📄 tcn--1.0.sql(274 B)
📄 tcn.control(134 B)
📄 timetravel--1.0.sql(486 B)
📄 timetravel--unpackaged--1.0.sql(394 B)
📄 timetravel.control(156 B)
📄 tsearch2--1.0.sql(15.35 KB)
📄 tsearch2--unpackaged--1.0.sql(8.89 KB)
📄 tsearch2.control(313 B)
📄 tsm_system_rows--1.0.sql(327 B)
📄 tsm_system_rows.control(186 B)
📄 tsm_system_time--1.0.sql(327 B)
📄 tsm_system_time.control(192 B)
📄 unaccent--1.0--1.1.sql(445 B)
📄 unaccent--1.1.sql(910 B)
📄 unaccent--unpackaged--1.0.sql(766 B)
📄 unaccent.control(157 B)

Editing: tsearch2--1.0.sql

/* contrib/tsearch2/tsearch2--1.0.sql */

-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION tsearch2" to load this file. \quit

-- These domains are just to catch schema-qualified references to the
-- old data types.
CREATE DOMAIN tsvector AS pg_catalog.tsvector;
CREATE DOMAIN tsquery AS pg_catalog.tsquery;
CREATE DOMAIN gtsvector AS pg_catalog.gtsvector;
CREATE DOMAIN gtsq AS pg_catalog.text;

--dict interface
CREATE FUNCTION lexize(oid, text)
	RETURNS _text
	as 'ts_lexize'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION lexize(text, text)
        RETURNS _text
        as 'MODULE_PATHNAME', 'tsa_lexize_byname'
        LANGUAGE C
        RETURNS NULL ON NULL INPUT;

CREATE FUNCTION lexize(text)
        RETURNS _text
        as 'MODULE_PATHNAME', 'tsa_lexize_bycurrent'
        LANGUAGE C
        RETURNS NULL ON NULL INPUT;

CREATE FUNCTION set_curdict(int)
	RETURNS void
	as 'MODULE_PATHNAME', 'tsa_set_curdict'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION set_curdict(text)
	RETURNS void
	as 'MODULE_PATHNAME', 'tsa_set_curdict_byname'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

--built-in dictionaries
CREATE FUNCTION dex_init(internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_dex_init'
	LANGUAGE C;

CREATE FUNCTION dex_lexize(internal,internal,int4)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_dex_lexize'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION snb_en_init(internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_snb_en_init'
	LANGUAGE C;

CREATE FUNCTION snb_lexize(internal,internal,int4)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_snb_lexize'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION snb_ru_init_koi8(internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_snb_ru_init_koi8'
	LANGUAGE C;

CREATE FUNCTION snb_ru_init_utf8(internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_snb_ru_init_utf8'
	LANGUAGE C;

CREATE FUNCTION snb_ru_init(internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_snb_ru_init'
	LANGUAGE C;

CREATE FUNCTION spell_init(internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_spell_init'
	LANGUAGE C;

CREATE FUNCTION spell_lexize(internal,internal,int4)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_spell_lexize'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION syn_init(internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_syn_init'
	LANGUAGE C;

CREATE FUNCTION syn_lexize(internal,internal,int4)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_syn_lexize'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION thesaurus_init(internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_thesaurus_init'
	LANGUAGE C;

CREATE FUNCTION thesaurus_lexize(internal,internal,int4,internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_thesaurus_lexize'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

--sql-level interface
CREATE TYPE tokentype
	as (tokid int4, alias text, descr text);

CREATE FUNCTION token_type(int4)
	RETURNS setof tokentype
	as 'ts_token_type_byid'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT
        ROWS 16;

CREATE FUNCTION token_type(text)
	RETURNS setof tokentype
	as 'ts_token_type_byname'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT
        ROWS 16;

CREATE FUNCTION token_type()
	RETURNS setof tokentype
	as 'MODULE_PATHNAME', 'tsa_token_type_current'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT
        ROWS 16;

CREATE FUNCTION set_curprs(int)
	RETURNS void
	as 'MODULE_PATHNAME', 'tsa_set_curprs'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION set_curprs(text)
	RETURNS void
	as 'MODULE_PATHNAME', 'tsa_set_curprs_byname'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

CREATE TYPE tokenout
	as (tokid int4, token text);

CREATE FUNCTION parse(oid,text)
	RETURNS setof tokenout
	as 'ts_parse_byid'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION parse(text,text)
	RETURNS setof tokenout
	as 'ts_parse_byname'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION parse(text)
	RETURNS setof tokenout
	as 'MODULE_PATHNAME', 'tsa_parse_current'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

--default parser
CREATE FUNCTION prsd_start(internal,int4)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_prsd_start'
	LANGUAGE C;

CREATE FUNCTION prsd_getlexeme(internal,internal,internal)
	RETURNS int4
	as 'MODULE_PATHNAME', 'tsa_prsd_getlexeme'
	LANGUAGE C;

CREATE FUNCTION prsd_end(internal)
	RETURNS void
	as 'MODULE_PATHNAME', 'tsa_prsd_end'
	LANGUAGE C;

CREATE FUNCTION prsd_lextype(internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_prsd_lextype'
	LANGUAGE C;

CREATE FUNCTION prsd_headline(internal,internal,internal)
	RETURNS internal
	as 'MODULE_PATHNAME', 'tsa_prsd_headline'
	LANGUAGE C;

--tsearch config
CREATE FUNCTION set_curcfg(int)
	RETURNS void
	as 'MODULE_PATHNAME', 'tsa_set_curcfg'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION set_curcfg(text)
	RETURNS void
	as 'MODULE_PATHNAME', 'tsa_set_curcfg_byname'
	LANGUAGE C
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION show_curcfg()
	RETURNS oid
	AS 'get_current_ts_config'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT STABLE;

CREATE FUNCTION length(tsvector)
	RETURNS int4
	AS 'tsvector_length'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION to_tsvector(oid, text)
	RETURNS tsvector
	AS 'to_tsvector_byid'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION to_tsvector(text, text)
	RETURNS tsvector
	AS 'MODULE_PATHNAME', 'tsa_to_tsvector_name'
	LANGUAGE C RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION to_tsvector(text)
	RETURNS tsvector
	AS 'to_tsvector'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION strip(tsvector)
	RETURNS tsvector
	AS 'tsvector_strip'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION setweight(tsvector,"char")
	RETURNS tsvector
	AS 'tsvector_setweight'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION concat(tsvector,tsvector)
	RETURNS tsvector
	AS 'tsvector_concat'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION querytree(tsquery)
	RETURNS text
	AS 'tsquerytree'
	LANGUAGE INTERNAL RETURNS NULL ON NULL INPUT;

CREATE FUNCTION to_tsquery(oid, text)
	RETURNS tsquery
	AS 'to_tsquery_byid'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION to_tsquery(text, text)
	RETURNS tsquery
	AS 'MODULE_PATHNAME','tsa_to_tsquery_name'
	LANGUAGE C RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION to_tsquery(text)
	RETURNS tsquery
	AS 'to_tsquery'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION plainto_tsquery(oid, text)
	RETURNS tsquery
	AS 'plainto_tsquery_byid'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION plainto_tsquery(text, text)
	RETURNS tsquery
	AS 'MODULE_PATHNAME','tsa_plainto_tsquery_name'
	LANGUAGE C RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION plainto_tsquery(text)
	RETURNS tsquery
	AS 'plainto_tsquery'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT IMMUTABLE;

--Trigger
CREATE FUNCTION tsearch2()
	RETURNS trigger
	AS 'MODULE_PATHNAME', 'tsa_tsearch2'
	LANGUAGE C;

--Relevation
CREATE FUNCTION rank(float4[], tsvector, tsquery)
	RETURNS float4
	AS 'ts_rank_wtt'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION rank(float4[], tsvector, tsquery, int4)
	RETURNS float4
	AS 'ts_rank_wttf'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION rank(tsvector, tsquery)
	RETURNS float4
	AS 'ts_rank_tt'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION rank(tsvector, tsquery, int4)
	RETURNS float4
	AS 'ts_rank_ttf'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION rank_cd(float4[], tsvector, tsquery)
        RETURNS float4
	AS 'ts_rankcd_wtt'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION rank_cd(float4[], tsvector, tsquery, int4)
	RETURNS float4
	AS 'ts_rankcd_wttf'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION rank_cd(tsvector, tsquery)
	RETURNS float4
	AS 'ts_rankcd_tt'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION rank_cd(tsvector, tsquery, int4)
	RETURNS float4
	AS 'ts_rankcd_ttf'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION headline(oid, text, tsquery, text)
	RETURNS text
	AS 'ts_headline_byid_opt'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION headline(oid, text, tsquery)
	RETURNS text
	AS 'ts_headline_byid'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION headline(text, text, tsquery, text)
	RETURNS text
	AS 'MODULE_PATHNAME', 'tsa_headline_byname'
	LANGUAGE C RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION headline(text, text, tsquery)
	RETURNS text
	AS 'MODULE_PATHNAME', 'tsa_headline_byname'
	LANGUAGE C RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION headline(text, tsquery, text)
	RETURNS text
	AS 'ts_headline_opt'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION headline(text, tsquery)
	RETURNS text
	AS 'ts_headline'
	LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

-- CREATE the OPERATOR class
CREATE OPERATOR CLASS gist_tsvector_ops
FOR TYPE tsvector USING gist
AS
        OPERATOR        1       @@ (tsvector, tsquery),
        FUNCTION        1       gtsvector_consistent (internal, tsvector, smallint, oid, internal),
        FUNCTION        2       gtsvector_union (internal, internal),
        FUNCTION        3       gtsvector_compress (internal),
        FUNCTION        4       gtsvector_decompress (internal),
        FUNCTION        5       gtsvector_penalty (internal, internal, internal),
        FUNCTION        6       gtsvector_picksplit (internal, internal),
        FUNCTION        7       gtsvector_same (gtsvector, gtsvector, internal),
        STORAGE         gtsvector;

--stat info
CREATE TYPE statinfo
	as (word text, ndoc int4, nentry int4);

CREATE FUNCTION stat(text)
	RETURNS setof statinfo
	as 'ts_stat1'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT;

CREATE FUNCTION stat(text,text)
	RETURNS setof statinfo
	as 'ts_stat2'
	LANGUAGE INTERNAL
	RETURNS NULL ON NULL INPUT;

--reset - just for debugging
CREATE FUNCTION reset_tsearch()
        RETURNS void
        as 'MODULE_PATHNAME', 'tsa_reset_tsearch'
        LANGUAGE C
        RETURNS NULL ON NULL INPUT;

--get cover (debug for rank_cd)
CREATE FUNCTION get_covers(tsvector,tsquery)
        RETURNS text
        as 'MODULE_PATHNAME', 'tsa_get_covers'
        LANGUAGE C
        RETURNS NULL ON NULL INPUT;

--debug function
create type tsdebug as (
        ts_name text,
        tok_type text,
        description text,
        token   text,
        dict_name text[],
        "tsvector" tsvector
);

CREATE FUNCTION _get_parser_from_curcfg()
RETURNS text as
$$select prsname::text from pg_catalog.pg_ts_parser p join pg_ts_config c on cfgparser = p.oid where c.oid = show_curcfg();$$
LANGUAGE SQL RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION ts_debug(text)
RETURNS setof tsdebug as $$
select
        (select c.cfgname::text from pg_catalog.pg_ts_config as c
         where c.oid = show_curcfg()),
        t.alias as tok_type,
        t.descr as description,
        p.token,
        ARRAY ( SELECT m.mapdict::pg_catalog.regdictionary::pg_catalog.text
                FROM pg_catalog.pg_ts_config_map AS m
                WHERE m.mapcfg = show_curcfg() AND m.maptokentype = p.tokid
                ORDER BY m.mapseqno )
        AS dict_name,
        strip(to_tsvector(p.token)) as tsvector
from
        parse( _get_parser_from_curcfg(), $1 ) as p,
        token_type() as t
where
        t.tokid = p.tokid
$$ LANGUAGE SQL RETURNS NULL ON NULL INPUT;

CREATE FUNCTION numnode(tsquery)
        RETURNS int4
        as 'tsquery_numnode'
        LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION tsquery_and(tsquery,tsquery)
        RETURNS tsquery
        as 'tsquery_and'
        LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION tsquery_or(tsquery,tsquery)
        RETURNS tsquery
        as 'tsquery_or'
        LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION tsquery_not(tsquery)
        RETURNS tsquery
        as 'tsquery_not'
        LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

--------------rewrite subsystem

CREATE FUNCTION rewrite(tsquery, text)
        RETURNS tsquery
        as 'tsquery_rewrite_query'
        LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION rewrite(tsquery, tsquery, tsquery)
        RETURNS tsquery
        as 'tsquery_rewrite'
        LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION rewrite_accum(tsquery,tsquery[])
        RETURNS tsquery
        AS 'MODULE_PATHNAME', 'tsa_rewrite_accum'
        LANGUAGE C;

CREATE FUNCTION rewrite_finish(tsquery)
      RETURNS tsquery
      as 'MODULE_PATHNAME', 'tsa_rewrite_finish'
      LANGUAGE C;

CREATE AGGREGATE rewrite (
      BASETYPE = tsquery[],
      SFUNC = rewrite_accum,
      STYPE = tsquery,
      FINALFUNC = rewrite_finish
);

CREATE FUNCTION tsq_mcontains(tsquery, tsquery)
        RETURNS bool
        as 'tsq_mcontains'
        LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE FUNCTION tsq_mcontained(tsquery, tsquery)
        RETURNS bool
        as 'tsq_mcontained'
        LANGUAGE INTERNAL
        RETURNS NULL ON NULL INPUT IMMUTABLE;

CREATE OPERATOR CLASS gist_tp_tsquery_ops
FOR TYPE tsquery USING gist
AS
        OPERATOR        7       @> (tsquery, tsquery),
        OPERATOR        8       <@ (tsquery, tsquery),
        FUNCTION        1       gtsquery_consistent (internal, tsquery, smallint, oid, internal),
        FUNCTION        2       gtsquery_union (internal, internal),
        FUNCTION        3       gtsquery_compress (internal),
        FUNCTION        4       gtsquery_decompress (internal),
        FUNCTION        5       gtsquery_penalty (internal, internal, internal),
        FUNCTION        6       gtsquery_picksplit (internal, internal),
        FUNCTION        7       gtsquery_same (bigint, bigint, internal),
        STORAGE         bigint;

CREATE OPERATOR CLASS gin_tsvector_ops
FOR TYPE tsvector USING gin
AS
        OPERATOR        1       @@ (tsvector, tsquery),
        OPERATOR        2       @@@ (tsvector, tsquery),
        FUNCTION        1       bttextcmp(text, text),
        FUNCTION        2       gin_extract_tsvector(tsvector,internal,internal),
        FUNCTION        3       gin_extract_tsquery(tsvector,internal,smallint,internal,internal,internal,internal),
        FUNCTION        4       gin_tsquery_consistent(internal,smallint,tsvector,int,internal,internal,internal,internal),
        FUNCTION        5       gin_cmp_prefix(text,text,smallint,internal),
        STORAGE         text;

CREATE OPERATOR CLASS tsvector_ops
FOR TYPE tsvector USING btree AS
        OPERATOR        1       < ,
        OPERATOR        2       <= ,
        OPERATOR        3       = ,
        OPERATOR        4       >= ,
        OPERATOR        5       > ,
        FUNCTION        1       tsvector_cmp(tsvector, tsvector);

CREATE OPERATOR CLASS tsquery_ops
FOR TYPE tsquery USING btree AS
        OPERATOR        1       < ,
        OPERATOR        2       <= ,
        OPERATOR        3       = ,
        OPERATOR        4       >= ,
        OPERATOR        5       > ,
        FUNCTION        1       tsquery_cmp(tsquery, tsquery);

Hackfut Security File Manager

Editing: tsearch2--1.0.sql

Upload File

Create Folder