From: Tom Lane <tgl@sss.pgh.pa.us>
To: Tomas Vondra <tomas@vondra.me>
cc: Marcos Pegoraro <marcos@f10.com.br>,
        pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: Why mention to Oracle ?
In-reply-to: <484a27f9-dea5-4734-93d5-90fb757080bc@vondra.me>
References: <CAB-JLwYfMxxGB1NADtS5MgPWk9FjfsuPgKMXOCmu_MmcivAbTA@mail.gmail.com> <484a27f9-dea5-4734-93d5-90fb757080bc@vondra.me>
Comments: In-reply-to Tomas Vondra <tomas@vondra.me>
	message dated "Fri, 20 Sep 2024 16:56:48 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <2440813.1726847629.1@sss.pgh.pa.us>
Date: Fri, 20 Sep 2024 11:53:49 -0400
Message-ID: <2440814.1726847629@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/2440814.1726847629%40sss.pgh.pa.us>
Precedence: bulk

Tomas Vondra <tomas@vondra.me> writes:
> On 9/20/24 14:36, Marcos Pegoraro wrote:
>> Why PostgreSQL DOCs needs to show or compare the Oracle way of doing
>> things ?

> I didn't dig into all the places you mention, but I'd bet those places
> reference Oracle simply because it was the most common DB people either
> migrated from or needed to support in their application next to PG, and
> thus were running into problems. The similarity of the interfaces and
> SQL dialects also likely played a role. It's less likely to run into
> subtle behavior differences e.g. SQL Server when you have to rewrite
> T-SQL stuff from scratch anyway.

As far as the mentions in "Data Type Formatting Functions" go, those
are there because those functions are not in the SQL standard; we
stole the API definitions for them from Oracle, lock stock and barrel.
(Except for the discrepancies that are called out by referencing what
Oracle does differently.)  A number of the other references probably
have similar origins.

			regards, tom lane