I encountered a problem when working with regular expressions in PostgreSQL. It turns out that PostgreSQL has no support for the p{Lo}
class, which corresponds to the “Letter, Other” category in the Unicode standard. I need to use this class in my regular expression, but I can’t find a way to do this in PostgreSQL.
I’m looking for an alternative approach or way to define this class through the available Unicode ranges in PostgreSQL. I would not want to manually list all possible characters as there are too many.
So far I’ve found a few Unicode ranges that partially fit:
[u0370-u03FFu0400-u04FFu0590-u05FFu0600-u06FFu3040-u30FFu30FFu4E00-u9FFF].
However these ranges are not enough to fully cover p{Lo}
. Maybe there is a more comprehensive way to represent p{Lo}
in PostgreSQL or some known method that can help to achieve similar functionality?
Any help or links to specific Unicode ranges that could match p{Lo}
would be greatly appreciated.
Thanks in advance!