类别:PostgreSQL

Netezza PureData中的Substring (SUBSTR)函数提供了基于字符串中的位置解析字符类型字段的功能。Substring函数语法Substring (<>，<< StartingPosition integer>>， <>) SUBSTR函数语法SUBSTR((<>，<< StartingPosition integer>>， <>) Example Substring SQL Substring SQL use In Example SELECT LOCATIONTEXT - From the Left of the String - - . Substring函数语法Substring (<>，<< StartingPosition integer>>， <>使用SUBSTRING函数，' ==SUBSTRING From the Left== ' as Divider1,SUBSTRING(LOCATIONTEXT,1,5) as Beggining_Using_SUBSTRING_LFT,SUBSTRING(LOCATIONTEXT,7,6) as Middle_Using_SUBSTRING_LFT， ' ==SUBSTR From the Left== ' as Divider2 -使用SUBSTR函数，SUBSTR(LOCATIONTEXT,1,5) as Beggining_Using_SUBSTRING_LFT,SUBSTR(LOCATIONTEXT,7,6) as Middle_Using_SUBSTR_LFT,SUBSTR(LOCATIONTEXT,7,6) as End_Using_SUBSTRING_LFT,SUBSTR(LOCATIONTEXT,7,6) as Middle_Using_SUBSTR_LFT,SUBSTR(LOCATIONTEXT,1,5) as End_Using_SUBSTRING_LFT,SUBSTR(LOCATIONTEXT,7,6) as End_Using_SUBSTRING_LFT -