Postgresql的字符串操作函数.docVIP

Postgresql的字符串操作函数 现把Postgresql的字符串操作函数罗列在以，以便日方使用 函数：string,,,,||,,,,string　 说明：String,,,,concatenation,,,,字符串连接操作 例子：Post,,,,||,,,,greSQL　＝　PostgreSQL ,,,, 函数：string,,,,||,,,,non-string,,,,or,,,,non-string,,,,||,,,,string 说明：String,,,,concatenation,,,,with,,,,one,,,,non-string,,,,input,,,,字符串与非字符串类型进行连接操作 例子：Value:,,,,,,,,||,,,,42,,,,=,,,,Value:,,,,42 ,,,, 函数：bit_length(string) 说明：Number,,,,of,,,,bits,,,,in,,,,string,,,,计算字符串的位数 例子：bit_length(jose),,,,=,,,,32 ,,,, 函数：char_length(string),,,,or,,,,character_length(string) 说明：Number,,,,of,,,,characters,,,,in,,,,string,,,,计算字符串中字符个数 例子：char_length(jose),,,,=,,,,4 ,,,, 函数：lower(string) 说明：Convert,,,,string,,,,to,,,,lower,,,,case,,,,转换字符串为小写 例子：bit_length(jose),,,,=,,,,32 ,,,, 函数：octet_length(string) 说明：Number,,,,of,,,,bytes,,,,in,,,,string,,,,计算字符串的字节数 例子：octet_length(jose),,,,=,,,,4 函数：overlay(string,,,,placing,,,,string,,,,from,,,,int,,,,[for,,,,int]) 说明：Replace,,,,substring,,,,替换字符串中任意长度的子字串为新字符串 例子：overlay(Txxxxas,,,,placing,,,,hom,,,,from,,,,2,,,,for,,,,4),,,,=,,,,4 函数：position(substring,,,,in,,,,string) 说明：Location,,,,of,,,,specified,,,,substring,,,,子串在一字符串中的位置 例子：position(om,,,,in,,,,Thomas),,,,=,,,,3 函数：substring(string,,,,[from,,,,int],,,,[for,,,,int]) 说明：Extract,,,,substring,,,,截取任意长度的子字符串 例子：substring(Thomas,,,,from,,,,2,,,,for,,,,3),,,,=,,,,hom 函数：substring(string,,,,from,,,,pattern) 说明：Extract,,,,substring,,,,matching,,,,POSIX,,,,regular,,,,expression.,,,,See,,,,Section,,,,9.7,,,,for,,,,more,,,,information,,,,on,,,,pattern,,,,matching.,,,,利用正则表达式对一字符串进行任意长度的字串的截取 例子：substring(Thomas,,,,from,,,,...$),,,,=,,,,mas 函数：substring(string,,,,from,,,,pattern,,,,for,,,,escape) 说明：Extract,,,,substring,,,,matching,,,,SQL,,,,regular,,,,expression.,,,,See,,,,Section,,,,9.7,,,,for,,,,more,,,,information,,,,on,,,,pattern,,,,matching.,,,,利于正则表达式对某类字符进行删除，以得到子字符串 例子：trim(both,,,,x,,,,from,,,,xTomxx),,,,=,,,,Tom 函数：trim([leading,,,,|,,,,trailing,,,,|,,,,both],,,,[characters],,,,from,,,,string),,,, 说明：Remove,,,,the,,,,longes