Re: add function argument name to substring and substr

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Marcos Pegoraro <marcos(at)f10(dot)com(dot)br>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: add function argument name to substring and substr
Date: 2025-04-01 13:20:13
Message-ID: B0D8D1E1-5209-4E32-B89E-360BC55A74F7@yesql.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On 1 Apr 2025, at 15:14, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> wrote:
>
> Em ter., 1 de abr. de 2025 às 02:00, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> escreveu:
>
> Wouldn't it be good to add the use of parentheses using posix ? It's useful and rarely documented
> <literal>substring('Thomas', '...$')</literal>
> + <literal>substring('Email: johnjohn(at)mymail(dot)com, Name: John' from '@(.*), Name')</literal>

While not commenting on the usefulness of the suggestion; any usage of email
addresses in the documentation should use @example.{com|org}.

--
Daniel Gustafsson

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Aleksander Alekseev 2025-04-01 13:26:13 Re: Adding skip scan (including MDAM style range skip scan) to nbtree
Previous Message Marcos Pegoraro 2025-04-01 13:14:58 Re: add function argument name to substring and substr