Postgresql数据库的一些字符串操作函数
PostgreSQL常用字符串函数和操作符
StartsWith是否为指定字符串开始
CREATE OR REPLACE FUNCTION StartsWith(_s varchar,_value varchar)returns boolean
AS $$
DECLARE _vlength integer;_slength integer;_var varchar;
BEGIN
_vlength := length(_value);
_slength := length(_s);
if _vlength=0 then
return true;
end if;
_var :=substring(_s,1,_vlength);
return _var=_value;
END;
$$ LANGUAGE PLPGSQL;
EndsWith是否为指定字符串结尾
CREATE OR REPLACE FUNCTION EndsWith(_S VARCHAR,_value VARCHAR) RETURNS BOOLEAN
AS $$
DECLARE _vlength integer;_slength integer;_var varchar;
BEGIN
_vlength := length(_value);
_slength := length(_s);
if _vlength=0 then
return true;
end if;
_var :=substring(_s,_slength-_vlength+1,_vlength);
return _var=_value;
END;
$$ LANGUAGE PLPGSQL;
调用方式为
ework=# select startswith('abcde','abc');
startswith
------------
t
(1 行记录)
ework=# select endswith('abc','bc');
endswith
----------
t
(1 行记录)