Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nxm6r-0005xE-UJ for pgsql-docs@arkaria.postgresql.org; Sun, 05 Jun 2022 08:59:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nxm6p-0002Kg-W3 for pgsql-docs@arkaria.postgresql.org; Sun, 05 Jun 2022 08:59:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nxm6p-0002KN-M8 for pgsql-docs@lists.postgresql.org; Sun, 05 Jun 2022 08:59:43 +0000 Received: from mail-yb1-xb2a.google.com ([2607:f8b0:4864:20::b2a]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nxm6n-0002tN-AJ for pgsql-docs@postgresql.org; Sun, 05 Jun 2022 08:59:42 +0000 Received: by mail-yb1-xb2a.google.com with SMTP id f34so20861884ybj.6 for ; Sun, 05 Jun 2022 01:59:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=roji.org; s=roji; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=7zcRFLRrWRN2nX4dG/4MYerJoC9qfgnq2Vb0BoPUdKA=; b=EjaA/OYmVnd4O0bFZeXKf29FZ+AMPrJCRQtkgINgcnL+BLLZF1l5CNlMPVNWaek6TT q8MLlMMM4aec3RjtAIi+WOdfNYpcO36KuDoXrXKr5EI/XWmtIFpGcZ6jYkd0Ytz8aQGC J5/bLhvDyL2lnO6FUqVgxgkZ2+9GsUMNsr5v8= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=7zcRFLRrWRN2nX4dG/4MYerJoC9qfgnq2Vb0BoPUdKA=; b=BmhtoCmu/3Vv+pxP5ue9zwBxnhYl4vj7p52p3Ms04lyCGP5zAt4UFJl9Whs9nZcFqx IVV65td2I/liCVegySyZVWNwsFsDbZR6hGHgpMmZSCFqARQwrrKEjsh0qk2y3Qz8/NVs LXwNPnzjkBJIZa/XTcn+6W0mok2pV7kDshoJSVig4Fai+lNUOXVXcE5ju2W4E7r/1V9x nVSboSsVIRZYBJnoeCuX3a9qoQMYlKLQve0vUOeF6idP+1Rt1aY1kmvFLBbrkff5Zo92 1Rd87aJtDEPIN7RhD6dKQkVCn9uM3zEvLfF5D+w05cD7slWMUixF5FsTsusz+ab7MBXr sJCw== X-Gm-Message-State: AOAM531/y+dvI2irYf34+auTw06uSdHZstVwFOo1NXh44xEnOxpxj4qF ohv4DrP4uwVzzn6nFdudchV/ckY4+BWBrWliwJ2/7w== X-Google-Smtp-Source: ABdhPJzHYtxHvxnJsuwFEp+UJUO1EuoSA1ndyFnb/LLFEzF/dxNpZUFBYs9TG2vv+rkW6ITxa0lJzmnqqbPkakfRC3o= X-Received: by 2002:a25:8252:0:b0:65d:1c9b:19af with SMTP id d18-20020a258252000000b0065d1c9b19afmr19554947ybn.15.1654419580520; Sun, 05 Jun 2022 01:59:40 -0700 (PDT) MIME-Version: 1.0 References: <20220605082743.dts3yqpgcuqnh5y4@jrouhaud> In-Reply-To: <20220605082743.dts3yqpgcuqnh5y4@jrouhaud> From: Shay Rojansky Date: Sun, 5 Jun 2022 10:59:29 +0200 Message-ID: Subject: Re: Lower/upper-case consistency with function names To: Julien Rouhaud Cc: pgsql-docs@postgresql.org Content-Type: multipart/alternative; boundary="000000000000681e2d05e0af933f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000681e2d05e0af933f Content-Type: text/plain; charset="UTF-8" On Sun, Jun 5, 2022 at 10:27 AM Julien Rouhaud wrote: > As mentioned in the doc in [3], COALESCE and all the others are actually not functions (those are specific keywords handled in the parser): Thanks. Yeah, I noticed that comment, but NULLIF which is also documented on that page isn't mentioned in that comment, but it's still shown in upper-case. It's maybe worth adding NULLIF to that comment. I'm also not sure I'd consider real/not real distinction as something that's very relevant to the user, to the extent that it warrants a case difference... But that doesn't matter much. --000000000000681e2d05e0af933f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sun, Jun 5, 2022 at 10:27 AM Julien Ro= uhaud <rjuju123@gmail.com> = wrote:

> As mentioned in = the doc in [3], COALESCE and all the others are actually not
functions= (those are specific keywords handled in the parser):

Thanks. Yeah, I noticed tha= t comment, but NULLIF which is also documented on that page isn't menti= oned in that comment, but it's still shown in upper-case. It's mayb= e worth adding NULLIF to that comment.

=
I'm also not sure I'd consider rea= l/not real distinction as something that's very relevant to the user, t= o the extent that it warrants a case difference... But that doesn't mat= ter much.
--000000000000681e2d05e0af933f--