On Tue, Feb 18, 2025 at 7:06 AM David G. Johnston
wrote:
>
> On Tue, Jan 21, 2025 at 11:29 PM jian he wrote:
>>
>> in 9.7.2 do you think it's worthwhile changing it to
>>
>> ""
>> As with SIMILAR TO, substring(string, pattern, escape-character)
>> the specified pattern must match the entire data
On Tue, Jan 21, 2025 at 11:29 PM jian he
wrote:
> in 9.7.2 do you think it's worthwhile changing it to
""
> As with SIMILAR TO, substring(string, pattern, escape-character)
> the specified pattern must match the entire data string, or else the
> function fails and returns null.
> ""
> ?
>
>
Maki
On Wed, Jan 22, 2025 at 12:53 AM Tom Lane wrote:
>
> jian he writes:
> > https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP
>
> > """
> > or as a plain three-argument function:
> > substring(string, pattern, escape-character)
> > """
>
> > but here "escape-
jian he writes:
> https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP
> """
> or as a plain three-argument function:
> substring(string, pattern, escape-character)
> """
> but here "escape-character" is optional.
> substring(string, pattern [,escape-charac
