Re: Use uppercase keywords in foreign key tutorial

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: jian he <jian(dot)universality(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Erik Wienhold <ewie(at)ewie(dot)name>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Euler Taveira <euler(at)eulerto(dot)com>, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Use uppercase keywords in foreign key tutorial
Date: 2025-11-11 13:12:31
Message-ID: 8f2e99ca-cce1-4b73-98ca-c4eec9aeb502@eisentraut.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On 10.11.25 04:15, jian he wrote:
> On Thu, Nov 6, 2025 at 11:06 AM David Rowley <dgrowleyml(at)gmail(dot)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.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2025-11-11 19:31:21 Quoting of *_command arguments
Previous Message David Rowley 2025-11-10 21:44:36 Re: MERGE command is not mentioned in the list of commands for variable substitution