Horton

Re: add function argument names to regex* functions.

jian he <jian.universality@gmail.com>

View thread View on postgr.es
From: jian he <jian.universality@gmail.com>
To: Peter Eisentraut <peter@eisentraut.org>
Cc: Dian Fay <di@nmfay.com>, Jim Nasby <jim.nasby@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-01-20T03:03:02Z
Lists: pgsql-hackers 
On Sat, Jan 20, 2024 at 10:55 AM jian he <jian.universality@gmail.com> wrote:
>
>
> another regex* function argument changes: from "N" to "occurences",  example:
>     + If <replaceable>occurrence</replaceable> is specified
>     + then the <replaceable>occurrence</replaceable>'th match of the pattern
>     + is located,
>
> but [2] says
> Speaking of the "occurrence'th
> occurrence" is just silly, not to mention long and easy to misspell."
>

sorry.
[2], The reference link is
https://www.postgresql.org/message-id/1567465.1627860115%40sss.pgh.pa.us

my previous post will link to the whole thread.

Commits

  1. Doc: fix text's description of regexp_replace's arguments.

  2. Add argument names to the regexp_XXX functions.

  3. Add assorted new regexp_xxx SQL functions.