pg中position、split_part、translate、strpos、length函数

select position('.' in '1.1.2.10');

select split_part('1.1.2.10','.',length('1.1.2.10') - length(translate('1.1.2.10','.',''))+1);

select split_part('1.1.2','.',length('1.1.2') - length(translate('1.1.2','.',''))+1);

select length(translate('1.1.2.10',’.’,’a’))+1 as num

select translate('1.1.2.10','.','')

select strpos('1.1.2.10','.')

select instr('1.1.2.10','.',1,3)

 

select length('1.1.2.10') - length(translate('1.1.2.10','.',''))

转载于:https://www.cnblogs.com/jcfxl/p/11496307.html