pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Chapman Flack <jcflack@acm.org>
To: jian he <jian.universality@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Peter Eisentraut <peter@eisentraut.org>
Cc: Dian Fay <di@nmfay.com>
Cc: Jim Nasby <jim.nasby@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: add function argument names to regex* functions.
Date: Mon, 15 Jul 2024 10:46:06 -0400
Message-ID: <6695362E.4010202@acm.org> (raw)
In-Reply-To: <CACJufxGJavz+UTJLBw=qTMZywG7E24oKNxp5B4+4uRHmXCW8Og@mail.gmail.com>
References: <CACJufxG3NFKKsh6x4fRLv8h3V-HvN4W5dA=zNKMxsNcDwOKang@mail.gmail.com>
	<CY3KI01TXYMD.3Q41WQ6U0NFEO@nmfay.com>
	<0eb3a5d7-75d8-4da5-9c88-a93deccdaa03@gmail.com>
	<CY5G4TAMVX32.23TH6LFF93ATZ@nmfay.com>
	<75129a34-14da-48aa-9906-42062fe78664@gmail.com>
	<CACJufxHBx+AHGVJocDSD-PbX0z32vJR9eEUhB+vsJHbjwnXNcg@mail.gmail.com>
	<CY8WQVZ0PK1B.19QRO61WBALCP@nmfay.com>
	<CACJufxHTw22kOmmDBpubmju9bfFhonEekwf0s6LGvysbnWEg9Q@mail.gmail.com>
	<CY9RIU0NZPAE.XZOBLKSFPZZB@nmfay.com>
	<CACJufxHqg0xqq=OdfN8Pf0C_hvEf0OSXik_3Yr0-QTAFUuHG=Q@mail.gmail.com>
	<f2b5ab0d-324c-4ba9-959e-67420bac7738@eisentraut.org>
	<CACJufxHZuQF8RkHHd83sqAeFvWfbvBysUxzRarAOeYuCi=tTmg@mail.gmail.com>
	<1763682.1712090733@sss.pgh.pa.us>
	<CACJufxGpgsQgnRvcPLczTV1Ak=JS0LmHxWe4q4dv6Qd1tRkQ9A@mail.gmail.com>
	<CA+TgmoZYDN7BEQzpanKVvjEK48cn7Rq95_jjn=wTe2gM4-2J5w@mail.gmail.com>
	<1816377.1715800208@sss.pgh.pa.us>
	<CACJufxGJavz+UTJLBw=qTMZywG7E24oKNxp5B4+4uRHmXCW8Og@mail.gmail.com>

On 07/15/24 08:02, jian he wrote:
> also address Chapman Flack point:
> correct me if i am wrong, but i don't think the ISO standard mandates
> function argument names.
> So we can choose the best function argument name for our purpose?

Ah, I may have mistaken which functions the patch meant to apply to.

These being the non-ISO regexp_* functions using POSIX expressions,
the ISO standard indeed says nothing about them.

In the ISO standard *_regex "functions", there are not really "function
argument names" mandated, because, like so many things in ISO SQL, they
have their own special syntax instead of being generic function calls:

TRANSLATE_REGEX('a|e|i|o|u' FLAG 'i' IN 'A PostgreSQL function'
 WITH 'X' FROM 1 OCCURRENCE 3);

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.

Regards,
-Chap





view thread (48+ messages)  latest in thread

Message-ID: <6695362E.4010202@acm.org>
Permalink:  ../6695362E.4010202@acm.org/
Also on:    postgresql.org/message-id/6695362E.4010202@acm.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: jcflack@acm.org, jian.universality@gmail.com, tgl@sss.pgh.pa.us, robertmhaas@gmail.com, peter@eisentraut.org, di@nmfay.com, jim.nasby@gmail.com, pgsql-hackers@lists.postgresql.org
  Subject: Re: add function argument names to regex* functions.
  In-Reply-To: <6695362E.4010202@acm.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox