| 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.
| 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 |