Horton

Re: add function argument names to regex* functions.

Peter Eisentraut <peter@eisentraut.org>

View thread View on postgr.es
From: Peter Eisentraut <peter@eisentraut.org>
To: Chapman Flack <chap@anastigmatix.net>, jian he <jian.universality@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Dian Fay <di@nmfay.com>, Jim Nasby <jim.nasby@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2024-07-25T13:42:29Z
Lists: pgsql-hackers 
On 15.07.24 16:52, Chapman Flack wrote:
> On 07/15/24 10:46, Chapman Flack wrote:
>> Ah, I may have mistaken which functions the patch meant to apply to.
>> ...
>> Any choice to use similar argument names in the regexp_* functions would
>> be a matter of consistency with the analogous ISO functions, not anything
>> mandated.
> 
> Or, looking back, I might have realized these were the non-ISO regexp_*
> functions, but seen there was bikeshedding happening over the best name
> to use for the occurrence argument, and merely suggested ISO's choice
> OCCURRENCE for the analogous ISO functions, as a possible bikeshed
> accelerator.

These functions were copied from Oracle, so one argument was to use the 
names from Oracle as-is.

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.