change regexp_substr first argument make tests more easier to understand.

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: change regexp_substr first argument make tests more easier to understand.
Date: 2023-12-27 16:13:14
Message-ID: CACJufxH4gw3Ej-90xjDz_7Xk=XfynRqpz6UyS0oQkCWQqY=d=g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi.
https://git.postgresql.org/cgit/postgresql.git/tree/src/test/regress/expected/strings.out#n928

SELECT regexp_substr('abcabcabc', 'a.c');
SELECT regexp_substr('abcabcabc', 'a.c', 2);
SELECT regexp_substr('abcabcabc', 'a.c', 1, 3);
SELECT regexp_substr('abcabcabc', 'a.c', 1, 4) IS NULL AS t;
SELECT regexp_substr('abcabcabc', 'A.C', 1, 2, 'i');

they all return 'abc', there are 3 'abc ' in string 'abcabcabc'
except IS NULL query.
maybe we can change regexp_substr first argument from "abcabcabc" to
"abcaXcaYc".
so the result would be more easier to understand.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Banck 2023-12-27 16:19:54 [PATCH] Exponential backoff for auth_delay
Previous Message Nathan Bossart 2023-12-27 15:36:47 Re: trying again to get incremental backup