Re: Use uppercase keywords in foreign key tutorial - Mailing list pgsql-docs

From Peter Eisentraut
Subject Re: Use uppercase keywords in foreign key tutorial
Date
Msg-id 8f2e99ca-cce1-4b73-98ca-c4eec9aeb502@eisentraut.org
Whole thread Raw
In response to Re: Use uppercase keywords in foreign key tutorial  (jian he <jian.universality@gmail.com>)
List pgsql-docs
On 10.11.25 04:15, jian he wrote:
> On Thu, Nov 6, 2025 at 11:06 AM David Rowley <dgrowleyml@gmail.com> wrote:
>>
>> I reviewed this and double checked you left "uPDaTE" in [1]. Found no
>> issues, so pushed.
>>
> 
> hi.
> 
> in doc/src/sgml/func/func-matching.sgml
> 
> <synopsis>
> substring(<replaceable>string</replaceable> similar
> <replaceable>pattern</replaceable> escape
> <replaceable>escape-character</replaceable>)
> </synopsis>
>      or using the now obsolete SQL:1999 syntax:
> <synopsis>
> substring(<replaceable>string</replaceable> from
> <replaceable>pattern</replaceable> for
> <replaceable>escape-character</replaceable>)
> </synopsis>
>      or as a plain three-argument function:
> <synopsis>
> substring(<replaceable>string</replaceable>,
> <replaceable>pattern</replaceable>,
> <replaceable>escape-character</replaceable>)
> </synopsis>
> 
> key word: "similar", "escape", "from", "for" within the above synopsis
> section need uppercase too?

I don't think that would be a good change.  substring is also a keyword, 
but it was said not to upper-case keywords used as functions.  So in my 
mind that should also apply to other syntax elements of function-like calls.




pgsql-docs by date:

Previous
From: David Rowley
Date:
Subject: Re: MERGE command is not mentioned in the list of commands for variable substitution
Next
From: Bruce Momjian
Date:
Subject: Quoting of *_command arguments