Horton

Re: Why mention to Oracle ?

Marcos Pegoraro <marcos@f10.com.br>

View thread
From: Marcos Pegoraro <marcos@f10.com.br>
To: Roberto Mello <roberto.mello@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>, "Jonah H. Harris" <jonah.harris@gmail.com>, Tomas Vondra <tomas@vondra.me>, "David G. Johnston" <david.g.johnston@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2024-09-24T15:59:26Z
Lists: pgsql-hackers 
Em dom., 22 de set. de 2024 às 12:49, Roberto Mello <roberto.mello@gmail.com>
escreveu:

> If you're volunteering to add a MySQL, SQL Server, Mongo, etc porting to
> the docs, I'm sure it could be a
> nice addition.
>

And if we create a page like https://www.postgresql.org/about/featurematrix/
But instead of Postgres versions we have other vendors.
Every feature would have a Postgres way of doing and what differs from his
old database.
Feature PostgreSQL Oracle SQL Server MySQL Firebird
SELECT  N ROWS LIMIT 10   TOP 10   FIRST 10
CONCAT STRINGS 'Name: ' || Name    'Name: ' + Name
REBUILD INDEX REINDEX ALTER INDEX… REBUILD
CURRENT DATE CURRENT_DATE   GETDATE
This is just an example, for sure there would be several tables, for DMLs,
for DDL, for Maintenance ...

What do you think ?

regards
Marcos