<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Mat3o的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Mat3o</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Mat3o]]></copyright><item><title><![CDATA[pgsql实现类似substring_index截取字符串的效果]]></title><link>https://blog.youkuaiyun.com/Mat3o/article/details/122679819</link><guid>https://blog.youkuaiyun.com/Mat3o/article/details/122679819</guid><author>Mat3o</author><pubDate>Tue, 25 Jan 2022 10:10:59 +0800</pubDate><description><![CDATA[数据需求：

例如该字符串：[{"Value":"18900000000","Note":"2020年报"},{"Value":"19100000000","Note":"企业官网"}]
想要截取第三次出现"和第四次出现"中间的内容，即18900000000

由于postgresql没有substring_index函数，需要截取的字符串长度也不确定，可以使用split_part()达到类似的效果。


select split_part('[{"Value":"18900000000","No...]]></description><category></category></item></channel></rss>