Details
-
Improvement
-
Status: Resolved
-
Major
-
Resolution: Resolved
-
None
-
None
-
None
-
None
Description
use like below descripyon:
>>select split_part('sa:sbl:sc', ':', 1) from t038sf;
(EXPR)
---------
sa
— 1 row(s) selected.
>>select split_part('sa:sbl:sc', ':', 2) from t038sf;
(EXPR)
---------
sbl
— 1 row(s) selected.
>>select split_part('sa:sbl:sc', ':', 3) from t038sf;
(EXPR)
---------
sc
— 1 row(s) selected.
>>
>>-- *ERROR*
>>select split_part('sa:sbl:sc', ':', 0) from t038sf;
-
-
- ERROR[4497] The Third operand of split_part must be greater than 0
-
— 0 row(s) selected.
>>–*EMPTY RESULT*
>>select split_part('sa:sbl:sc', ':', 4) from t038sf;
(EXPR)
---------
— 1 row(s) selected.
>> create table T038sf(a int, b char(10), c varchar(30));
>>insert into T038sf values(110, 'a/b/c', 'sa/dsd/s');
— 1 row(s) inserted.
>>insert into T038sf values(111, 'sasd', 'dsa:/~sd');
— 1 row(s) inserted.
>>insert into T038sf values(112, '#$%$#@', 'dsasggggsad');
— 1 row(s) inserted.
>>insert into T038sf values(114, 'a', '这是^中文:测试');
— 1 row(s) inserted.
>>select split_part(c, '/', 2) from t038sf;
(EXPR)
------------------------------
dsd
~sd
— 4 row(s) selected.
>>select split_part(c, 'ggg', 2) from t038sf;
(EXPR)
------------------------------
gsad
— 4 row(s) selected.
>>select split_part(c, 'sd', 1) from t038sf;
(EXPR)
------------------------------
sa/d
dsa:/~
— 4 row(s) selected.
>>select split_part(c, ':', 1) from t038sf;
(EXPR)
------------------------------
这是^中文
— 4 row(s) selected.