Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vIIOJ-002keq-TJ for pgsql-docs@arkaria.postgresql.org; Mon, 10 Nov 2025 03:16:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vIIOH-00DSb9-Di for pgsql-docs@arkaria.postgresql.org; Mon, 10 Nov 2025 03:16:25 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vIIOH-00DSZE-3q for pgsql-docs@lists.postgresql.org; Mon, 10 Nov 2025 03:16:25 +0000 Received: from mail-vs1-xe30.google.com ([2607:f8b0:4864:20::e30]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vIIOF-006J6U-1P for pgsql-docs@lists.postgresql.org; Mon, 10 Nov 2025 03:16:24 +0000 Received: by mail-vs1-xe30.google.com with SMTP id ada2fe7eead31-5dbe6be1ac5so1119652137.1 for ; Sun, 09 Nov 2025 19:16:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762744582; x=1763349382; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=RpPJj6gOsxtuafWf6GvFRSdVOZaPszD5qURY9Jp8nDc=; b=dcz0nC6NjMpOYx+z+V8roPCv+pzlD5JPlMfwXq1StzWQ5zj4zWLLF2eAZB+hkK8t4A QoVcMSKkUhogf8bqSJwBPhLzpvqkSwfV5qcTL67NHvl7VWSNloxTHWnOdcdSN6JlgZDV nhaghk9SUSycnzsvSEeN6D8x3fsRg+FxuckDCvYFKB9uACSRNANxkp8DIT5+hDU2LoLd 84uVFANoDcnJGE6f8G4k4gZPNpLQ9FC/7MZET8/v7j91bT01twA1Uc3XIt21iNgrfW++ jdWzGSBJJA+J15SJQE4MHgxDW1fAYDJMsCd6e7ao6CqFc8orTFSZkDmurSx0tXsWuwJv HZNg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762744582; x=1763349382; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=RpPJj6gOsxtuafWf6GvFRSdVOZaPszD5qURY9Jp8nDc=; b=k9JNBgLA/lxonGU5vcmhp7LLn0tsE5Sr1HII9pn+6PiHUSc+Op2IGr66jWAsWdHycc 9FxajJKSQhFMlfyqMywN9ZsfSsA9yC0FJtwpxBbAG01NCtoO6TDtbYlW1WI+5ZwJQvJg JDzRvkLYS+IS0ekghHW2fy6wQLRbunz+1U8a91EcZ+kTtsv7CUaAH2az4sbcJk5eu12b 3jEmq45GhM0vEP8xdwmbSc0KwTomoF9jKkzk6zioHuiC0ggxpIct0C+i731NZQjkm+1X 3H9Ok1a37Q9co8RM0TlANdw57GhEE+yXTY60Rapdqvgn9fn61NwZlRS8p19PU0zYdeGe llIA== X-Forwarded-Encrypted: i=1; AJvYcCUS2lJpTnW4b7x4TCt6I4MZwkOO8MS2lnpClTKUwcoTHr9f32i97geyK6gUD7kvSg7Hdk+EHTLCZIE8@lists.postgresql.org X-Gm-Message-State: AOJu0YwPoOOThxJ0dlvRYGYBwfDMm0C47q6efIEhOBXZUSknQDQf75S+ 3TekCkN7Fb2voY/x6fRmBXGR1uqqvUUPbeZKQgoys8W5CiI+sPF8iHnxXYGI+DEDu4MZ70rmV5L EqEUVFGO+pssn2Q4e77dGEhqmxW724Z0= X-Gm-Gg: ASbGncuM52qrILBk/FZooYGvcfOJlRD/w672JJrXfdN26ECkvhRTdPWc797PbzO3RMY A1d942EcuKrnio36kC64HNphibVfNV7Cj+p4yMiYKrJCaDujuKSw3d+PjwGyldWOU27E5GObNAk cktlxiVB/4IHWwA8BdtnSBWplfxwlfWc/m3kAwileti53VkrxmHbjw8Cu6DyuaDkE9/TATJUWsG s7xUoTNOgZii+6XBx0oZcV1czOx0hL/uYoyuzqPi2965XyEdb9zGR88k6nTjIllGRaXva0FmSYs y7tCDco4iEsn58+o5seu+xKgfnw+IY55zGmjryK9wV0C1mtzuBNLbQ/2uCbsi7VnjkGZqJ8K8WE KeG5BjCAaVws3bqL0SDedVyp41OZnFADxjUBYeQuL8yR1mP1ZKzMY8BjY5oO3PXzGJv0i4Yi185 CXrfTylYkY X-Google-Smtp-Source: AGHT+IENA+tnoVtUdmoCxjwa3uC6Wo2A7qFYeo/tYmUTtgocfq17iM5mI7o4AhF6b0mHIgCC93mlpqt6NrD8+76ft8k= X-Received: by 2002:a05:6102:26d1:b0:5db:3d11:c8d6 with SMTP id ada2fe7eead31-5ddc467fd5bmr1935055137.5.1762744582423; Sun, 09 Nov 2025 19:16:22 -0800 (PST) MIME-Version: 1.0 References: <2903384.1761770924@sss.pgh.pa.us> <0a68a965-4599-4af1-a1eb-bd8e1be75788@ewie.name> <32882add-b671-42db-a041-e2c2c5b7c315@ewie.name> <4487a138-c4d2-4b06-80b3-5afe7f8e5d82@ewie.name> <971a5a3d-c200-4700-824b-f71a6e831994@ewie.name> In-Reply-To: From: jian he Date: Mon, 10 Nov 2025 11:15:46 +0800 X-Gm-Features: AWmQ_bkIsyYaynEcJQ3Ahxzr7t8hWgpXE6Qjkpnxu-EITaDiOJ94tdP4dY2LCSs Message-ID: Subject: Re: Use uppercase keywords in foreign key tutorial To: David Rowley Cc: Erik Wienhold , Tom Lane , Bruce Momjian , Nathan Bossart , Euler Taveira , pgsql-docs@lists.postgresql.org Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Nov 6, 2025 at 11:06=E2=80=AFAM David Rowley = 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 substring(string similar pattern escape escape-character) or using the now obsolete SQL:1999 syntax: substring(string from pattern for escape-character) or as a plain three-argument function: substring(string, pattern, escape-character) key word: "similar", "escape", "from", "for" within the above synopsis section need uppercase too? -- jian https://www.enterprisedb.com/