3 ms·
PL/SQL and T-SQL are the names of the stored procedure languages - postgres' on of those is PL/PGSQL. All three have variations from ANSI SQL in their non-spro
by mst 7y ago
PL/SQL and T-SQL are the names of the stored procedure languages - postgres' on of those is PL/PGSQL.
All three have variations from ANSI SQL in their non-sproc SQL too, oracle's far worse than the other two, but pg and SQL Server document where they deviate pretty damn well.
There definitely were ANSI examples in there, "ORDER BY 2" is in ANSI (and IIRC plenty of pre-ANSI dialects as well) for a start, I'm too tired (and/or lazy) to go back and look for others, sorry.