EXTENSION = citext

DATA = citext--1.4.sql\

citext--1.7--1.8.sql\

citext--1.6--1.7.sql\

citext--1.5--1.6.sql\

citext--1.4--1.5.sql\

\echo Use"ALTER EXTENSION citext UPDATE TO '1.8'" to load this file. \quit

CREATE OR REPLACEFUNCTIONregexp_match(string citext, pattern citext) RETURNSTEXT[]

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.regexp_match( $1::text, $2::text,'i' );

CREATE OR REPLACEFUNCTIONregexp_match(string citext, pattern citext, flagstext) RETURNSTEXT[]

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.regexp_match( $1::text, $2::text, CASE WHENpg_catalog.strpos($3,'c')=0 THEN $3||'i' ELSE $3 END );

CREATE OR REPLACEFUNCTIONregexp_matches(string citext, pattern citext) RETURNS SETOFTEXT[]

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE ROWS1

RETURNpg_catalog.regexp_matches( $1::text, $2::text,'i' );

CREATE OR REPLACEFUNCTIONregexp_matches(string citext, pattern citext, flagstext) RETURNS SETOFTEXT[]

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE ROWS10

RETURNpg_catalog.regexp_matches( $1::text, $2::text, CASE WHENpg_catalog.strpos($3,'c')=0 THEN $3||'i' ELSE $3 END );

CREATE OR REPLACEFUNCTIONregexp_replace(string citext, pattern citext, replacementtext) returnsTEXT

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.regexp_replace( $1::text, $2::text, $3,'i');

CREATE OR REPLACEFUNCTIONregexp_replace(string citext, pattern citext, replacementtext, flagstext) returnsTEXT

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.regexp_replace( $1::text, $2::text, $3, CASE WHENpg_catalog.strpos($4,'c')=0 THEN $4||'i' ELSE $4 END);

CREATE OR REPLACEFUNCTIONregexp_split_to_array(string citext, pattern citext) RETURNSTEXT[]

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.regexp_split_to_array( $1::text, $2::text,'i' );

CREATE OR REPLACEFUNCTIONregexp_split_to_array(string citext, pattern citext, flagstext) RETURNSTEXT[]

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.regexp_split_to_array( $1::text, $2::text, CASE WHENpg_catalog.strpos($3,'c')=0 THEN $3||'i' ELSE $3 END );

CREATE OR REPLACEFUNCTIONregexp_split_to_table(string citext, pattern citext) RETURNS SETOFTEXT

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.regexp_split_to_table( $1::text, $2::text,'i' );

CREATE OR REPLACEFUNCTIONregexp_split_to_table(string citext, pattern citext, flagstext) RETURNS SETOFTEXT

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.regexp_split_to_table( $1::text, $2::text, CASE WHENpg_catalog.strpos($3,'c')=0 THEN $3||'i' ELSE $3 END );

CREATE OR REPLACEFUNCTIONstrpos( citext, citext ) RETURNSINT

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.strpos(pg_catalog.lower( $1::text ),pg_catalog.lower( $2::text ) );

CREATE OR REPLACEFUNCTIONreplace( citext, citext, citext ) RETURNSTEXT

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.regexp_replace( $1::text,pg_catalog.regexp_replace($2::text,'([^a-zA-Z_0-9])', E'\\\\\\1','g'), $3::text,'gi' );

CREATE OR REPLACEFUNCTIONsplit_part( citext, citext,int ) RETURNSTEXT

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURN (pg_catalog.regexp_split_to_array( $1::text,pg_catalog.regexp_replace($2::text,'([^a-zA-Z_0-9])', E'\\\\\\1','g'),'i'))[$3];

CREATE OR REPLACEFUNCTIONtranslate( citext, citext,text ) RETURNSTEXT

LANGUAGE SQL IMMUTABLE STRICT PARALLEL SAFE

RETURNpg_catalog.translate(pg_catalog.translate( $1::text,pg_catalog.lower($2::text), $3),pg_catalog.upper($2::text), $3);

# citext extension

comment = 'data type for case-insensitive character strings'

default_version = '1.7'

default_version = '1.8'

module_pathname = '$libdir/citext'

relocatable = true

trusted = true

'citext--1.4--1.5.sql',

'citext--1.5--1.6.sql',

'citext--1.6--1.7.sql',

'citext--1.7--1.8.sql',

kwargs: contrib_data_args,

)