On 2020-12-03 00:54, Michael Paquier wrote:
I got to wonder about the impact when migrating applications though. SELECT INTO has a different meaning in Oracle, but SQL server creates a new table like Postgres.
Interesting. This appears to be the case. SQL Server uses SELECT INTO to create a table, and does not appear to have CREATE TABLE AS.
So maybe we should keep it, but adjust the documentation to point out this use case.
[some snarky comment about AWS Babelfish here ... ;-) ]