> On 1 Apr 2025, at 15:14, Marcos Pegoraro wrote:
>
> Em ter., 1 de abr. de 2025 às 02:00, David G. Johnston
> escreveu:
>
> Wouldn't it be good to add the use of parentheses using posix ? It's useful
> and rarely documented
> substring('Thomas', '...$')
> +substring('Email: j
Em ter., 1 de abr. de 2025 às 02:00, David G. Johnston <
david.g.johns...@gmail.com> escreveu:
Wouldn't it be good to add the use of parentheses using posix ? It's useful
and rarely documented
substring('Thomas', '...$')
+substring('Email: johnj...@mymail.com, Name: John' from
'@(.
On Tue, Apr 1, 2025 at 6:15 AM Marcos Pegoraro wrote:
> Em ter., 1 de abr. de 2025 às 02:00, David G. Johnston <
> david.g.johns...@gmail.com> escreveu:
>
> Wouldn't it be good to add the use of parentheses using posix ? It's
> useful and rarely documented
> substring('Thomas', '...$')
>
On Mon, Mar 31, 2025 at 9:12 PM jian he wrote:
> On Tue, Apr 1, 2025 at 6:22 AM David G. Johnston
> wrote:
> >
> > On Tue, Mar 18, 2025 at 9:04 PM jian he
> wrote:
> >>
> >>
> >> new patch attached.
> >>
> >
> > I've done v4 with a delta patch.
>
> your v4-0001-v3-0001-substring.patch is not th
On Tue, Apr 1, 2025 at 6:22 AM David G. Johnston
wrote:
>
> On Tue, Mar 18, 2025 at 9:04 PM jian he wrote:
>>
>>
>> new patch attached.
>>
>
> I've done v4 with a delta patch.
>
> Decided to standardize on calling the SQL Similar To regular expression
> escape replaceable "escape" everywhere.
>
On Tue, Mar 18, 2025 at 9:04 PM jian he wrote:
>
> new patch attached.
>
>
I've done v4 with a delta patch.
Decided to standardize on calling the SQL Similar To regular expression
escape replaceable "escape" everywhere.
Instead of fully documenting the obsolete syntax I added a note explaining
hi.
new patch attached.
now \df substring looks like:
List of functions
Schema | Name| Result data type | Argument
data types| Type
+---+--+---
On Tue, Mar 18, 2025 at 6:20 PM jian he wrote:
> On Wed, Mar 19, 2025 at 8:19 AM David G. Johnston
> wrote:
> >
> > The vast majority of examples throughout the manual use traditional
> function call syntax func_name(arg1, arg2, etc.); I'd rather keep with
> convention than start to scatter ab
On Wed, Mar 19, 2025 at 8:19 AM David G. Johnston
wrote:
>
> The vast majority of examples throughout the manual use traditional function
> call syntax func_name(arg1, arg2, etc.); I'd rather keep with convention
> than start to scatter about alternative syntax choices just to give the
> rand
On Mon, Mar 17, 2025 at 8:20 PM jian he wrote:
> On Tue, Feb 18, 2025 at 6:13 AM David G. Johnston
> wrote:
> >
> > Table 9.9 limits itself to those functions defined in the SQL standard;
> which are basically the ones that use keywords instead of commas.
> >
> > The substring(string, start, cou
On Tue, Feb 18, 2025 at 6:13 AM David G. Johnston
wrote:
>
> Table 9.9 limits itself to those functions defined in the SQL standard; which
> are basically the ones that use keywords instead of commas.
>
> The substring(string, start, count) function you note is already covered in
> Table 9.10 bu
On Mon, 27 Jan 2025 at 07:51, jian he wrote:
>
> hi.
>
> I forgot to attach the patch.
> here we are.
I noticed that David's comments from [1] have not yet been addressed,
I have changed the status of commitfest entry to "Waiting on Author",
please address them and change the status to "Needs rev
On Tue, Jan 21, 2025 at 11:21 PM jian he
wrote:
> hi.
>
> attached patch add function argument name to function substring and substr
> you can see the visual changes.
> mater behavior:
>
> \df substring
> List of functions
>Schema | Name| Result data type
hi.
I forgot to attach the patch.
here we are.
From 249a083627b0d8ad15c698601f7b7649be5262a1 Mon Sep 17 00:00:00 2001
From: jian he
Date: Wed, 22 Jan 2025 14:19:15 +0800
Subject: [PATCH v1 1/1] add function argument name to function substring and
substr
---
src/backend/catalog/system_functions
14 matches
Mail list logo
