public inbox for [email protected]  

help / color / mirror / Atom feed

From: Shay Rojansky <[email protected]>
To: [email protected]
Subject: Lower/upper-case consistency with function names
Date: Sun, 5 Jun 2022 10:20:23 +0200
Message-ID: <CADT4RqDfNk1ML0hESamaQG5d8MkKuEy43vYuhT=pb95HxkSQWQ@mail.gmail.com> (raw)

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Lower/upper-case consistency with function names
  In-Reply-To: <CADT4RqDfNk1ML0hESamaQG5d8MkKuEy43vYuhT=pb95HxkSQWQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox