Differences between the regular expression times symbol in ORACLE and openGauss
Posted: Thu Jan 23, 2025 9:22 am
Looking to the future , Huawei Developer Space will continue to deepen its development and constantly improve product functions, becoming a solid partner for developers to ride the waves of technological waves , leading the industry to new heights, and working together to create a new future for technology.
report Gauss Squirrel Club Assistant Posted on 2025/01/10 15:18:17 6.2k+ 0 0
【Abstract】 Regular expressions are a common way to process strings. In various development languages and even databases, there are built-in regular expression functions. However, there are many standards for regular expressions, and different standards parse regular expressions differently. This time, when migrating an ORACLE database to openGauss, a difference about {} was found.
image.png
Author: DarkAthena
1. Introduction
As a common string processing method, regular expressions kuwait phone number data are built-in in various development languages and even databases. However, there are many standards for regular expressions, and different standards parse regular expressions differently. This time, when migrating an ORACLE database to openGauss, a difference in {} was found.
2. What is {} used for?
In most regular expression rules, {} represents the number of repetitions of the preceding character. The supported formats are {m}, {m,}, {,n}, and {m,n}, where m and n are both natural numbers. For example,
The rule here can be roughly described as follows in ORACLE:
If {} does not satisfy one of the following formats then is not used as a declaration symbol for the number of times, but is recognized as a regular string.
report Gauss Squirrel Club Assistant Posted on 2025/01/10 15:18:17 6.2k+ 0 0
【Abstract】 Regular expressions are a common way to process strings. In various development languages and even databases, there are built-in regular expression functions. However, there are many standards for regular expressions, and different standards parse regular expressions differently. This time, when migrating an ORACLE database to openGauss, a difference about {} was found.
image.png
Author: DarkAthena
1. Introduction
As a common string processing method, regular expressions kuwait phone number data are built-in in various development languages and even databases. However, there are many standards for regular expressions, and different standards parse regular expressions differently. This time, when migrating an ORACLE database to openGauss, a difference in {} was found.
2. What is {} used for?
In most regular expression rules, {} represents the number of repetitions of the preceding character. The supported formats are {m}, {m,}, {,n}, and {m,n}, where m and n are both natural numbers. For example,
The rule here can be roughly described as follows in ORACLE:
If {} does not satisfy one of the following formats then is not used as a declaration symbol for the number of times, but is recognized as a regular string.