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 1srhUd-003seU-0s for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2024 17:32:31 +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 1srhUZ-00AjPp-QV for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Sep 2024 17:32:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1srhUZ-00AjPd-C2 for pgsql-hackers@lists.postgresql.org; Fri, 20 Sep 2024 17:32:28 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1srhUW-000DmM-6S for pgsql-hackers@postgresql.org; Fri, 20 Sep 2024 17:32:27 +0000 Received: by mail-ed1-x52a.google.com with SMTP id 4fb4d7f45d1cf-5c44e1cde53so2790804a12.0 for ; Fri, 20 Sep 2024 10:32:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=f10-com-br.20230601.gappssmtp.com; s=20230601; t=1726853544; x=1727458344; darn=postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=BUo/AFF2RzBjgeaK6mTi4KvGIZUj6czGEaIQwApnV7E=; b=SYVyUhiqXcwXcDS4TNz6aMlZDqb5SIzid4u8GS6eFhH9ahnzOBcDqBNGaHdzZEg9r9 4X7yMBk5mWx/C1kQ7CyztH5lM3dWFzuoT4Q9GWDbzulOMbPdo98Jdg0HX0+S8sYUXl3D YDuqryNdYovwwHRR6SqR8mUb/7CrsOsBu1oJi8Ug7gryjHVqzdSF112LOln3xTb66P13 ZtiYBu7czpBkU4lfBD1lQqeoGIccXSTu/O5cepQ6uTNzTah/iBrv154FuWPxWNxCFUGm mtkN0abHn7uciX51HZCUSHTfqbeyhDAvZAzluvt4GfH08L3aGD1T1bUiQ16ViNHCWdOU gSmQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1726853544; x=1727458344; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=BUo/AFF2RzBjgeaK6mTi4KvGIZUj6czGEaIQwApnV7E=; b=mbCKYSG8s+KHOul9YwWbW5uSIUaT9VoGA8BtpSzwwOhU1A4xAwHnTQ114qoAbn2F7B QZ4uCX0bYBQmOFLBwvw4C2Xo3TKT2f5ZEGGvr0mOyfMm1KaKR8Nqks1+atmZF4KfTg8s M1dgBeQmzetFSnhKQ8K2EMGt6RYyhhkCVquWQWHNh/4Fitn+xDyJ04ctJz+Bw1JjqBC+ 97gGZxcrxnjVmHTXFW9myyaLKxskvIqOmW6pjleHidAgXrT6AXGRceh1byXYNvLpJ6C4 WPSwOi1eQs7WmIY1U3X0zRD0smaGaFnJVarjMVk/rteN5Bv7keCHIpZwQh+izOXZXZq9 ySQQ== X-Forwarded-Encrypted: i=1; AJvYcCWWmQ7NNXDNX7ziuWCiXXQ8HammiYlscigcJVrsYX/eucWemJSnQ8oQ9vsB5F9nc1BiPXxPgf+TRd+iiLcR@postgresql.org X-Gm-Message-State: AOJu0YzIZCt18h62mjAtoDDUiXNCpA19q1KaOyeqoaZje0ZvSt9ifTZJ TG2CmbaLK3Q7FUqowyyZwlC9TKXQD8owIp0SyhC71AyZ9oNWe7wzbV6Ft5iT5aLE2N1UK/l3AlW I9H53gpaw4RYqFaqThCDfzgLfdZYe0NAwVPsQ X-Google-Smtp-Source: AGHT+IEZnnMRc1HkddA5oMSXEHEFUfzxe5PssiJy2t2wjkHu6mzU8wbKjMC+8S5XVWRPd87LFFW/l27mcVdEZlwQzdo= X-Received: by 2002:a17:907:e629:b0:a86:97e5:8d4e with SMTP id a640c23a62f3a-a90d4ffde28mr310691266b.23.1726853544209; Fri, 20 Sep 2024 10:32:24 -0700 (PDT) MIME-Version: 1.0 References: <484a27f9-dea5-4734-93d5-90fb757080bc@vondra.me> <2440814.1726847629@sss.pgh.pa.us> In-Reply-To: <2440814.1726847629@sss.pgh.pa.us> From: Marcos Pegoraro Date: Fri, 20 Sep 2024 14:31:47 -0300 Message-ID: Subject: Re: Why mention to Oracle ? To: Tom Lane Cc: Tomas Vondra , pgsql-hackers Content-Type: multipart/alternative; boundary="0000000000001504cc0622906cb6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000001504cc0622906cb6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Em sex., 20 de set. de 2024 =C3=A0s 12:53, Tom Lane esc= reveu: > 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. > All the time we see somebody adding a new function to Postgres core that exists in Python or GO or MySQL, but none of them are mentioned on DOCS. I did never use Oracle but I'm almost sure on Oracle DOCS there are no mentions of Postgres, right ? Why do we need to mention it ? Regards Marcos --0000000000001504cc0622906cb6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Em sex., 20 de set. de = 2024 =C3=A0s 12:53, Tom Lane <tgl@s= ss.pgh.pa.us> escreveu:
As far as the mentio= ns 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.)=C2=A0 A number of the other references probably have similar origins.

All = the time we see somebody adding a new function to Postgres core that exists= in Python or GO or MySQL, but none of them are mentioned on DOCS.

I did never use Oracle but I= 'm almost sure on Oracle DOCS there are no mentions of Postgres, right = ? Why do we need to mention it ?

Regards
Marcos
--0000000000001504cc0622906cb6--