MIME-Version: 1.0
From: Shay Rojansky <roji@roji.org>
Date: Sun, 5 Jun 2022 10:20:23 +0200
Message-ID: 
 <CADT4RqDfNk1ML0hESamaQG5d8MkKuEy43vYuhT=pb95HxkSQWQ@mail.gmail.com>
Subject: Lower/upper-case consistency with function names
To: pgsql-docs@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000091a39d05e0af07e8"
Archived-At: 
 <https://www.postgresql.org/message-id/CADT4RqDfNk1ML0hESamaQG5d8MkKuEy43vYuhT%3Dpb95HxkSQWQ%40mail.gmail.com>
Precedence: bulk

--00000000000091a39d05e0af07e8
Content-Type: text/plain; charset="UTF-8"

Hi all,

The PostgreSQL docs mostly show function names in lowercase (e.g. [1],
[2]), which seems to be the PostgreSQL-idiomatic thing to do. However, some
pages show functions in upper case, e.g. COALESCE/NULLIF/GREATEST/LEAST
([3]). Is there some difference between these which warrants the case
difference, or just a case of docs inconsistency?

I ran into this while trying to make Entity Framework (.NET ORM) generate
more idiomatic-looking SQL. If this is just an inconsistency, it's
obviously not very important.

Thanks,

Shay
[1] https://www.postgresql.org/docs/current/functions-aggregate.html
[2] https://www.postgresql.org/docs/current/datatype-datetime.html
[3] https://www.postgresql.org/docs/current/functions-conditional.html

--00000000000091a39d05e0af07e8
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi all,<div><br></div><div>The PostgreSQL docs mostly show=
 function names in lowercase (e.g. [1], [2]), which seems to be the Postgre=
SQL-idiomatic thing to do. However, some pages show functions in upper case=
, e.g. COALESCE/NULLIF/GREATEST/LEAST ([3]). Is there some difference betwe=
en these which warrants the case difference, or just a case of docs inconsi=
stency?</div><div><br></div><div>I ran into this while trying to make Entit=
y Framework (.NET ORM) generate more idiomatic-looking SQL. If this is just=
 an inconsistency, it&#39;s obviously not very important.</div><div><br></d=
iv><div>Thanks,</div><div><br></div><div>Shay</div><div>[1]=C2=A0<a href=3D=
"https://www.postgresql.org/docs/current/functions-aggregate.html">https://=
www.postgresql.org/docs/current/functions-aggregate.html</a></div><div>[2]=
=C2=A0<a href=3D"https://www.postgresql.org/docs/current/datatype-datetime.=
html">https://www.postgresql.org/docs/current/datatype-datetime.html</a></d=
iv><div>[3]=C2=A0<a href=3D"https://www.postgresql.org/docs/current/functio=
ns-conditional.html">https://www.postgresql.org/docs/current/functions-cond=
itional.html</a></div></div>

--00000000000091a39d05e0af07e8--