Rob Verschoor
Rob Verschoor
T-SQL MERGE supports a number of commonly used syntactic and semantic aspects which PG does currently not support. Right now, the best workaround is to use the `-rewrite` feature of...
I reproduced the issue. it is being looked into.
PostgreSQL only supports what SQL Server would call WITH SCHEMABINDING. So a T-SQL view that is not specifying the SCHEMABINDING keyword is created as if SCHEMABINDING was specified (the Compass...
Technically, this may be possible, but it is not supported from a Babelfish perspective. The reason is that there may be difficult interoperability issues for which it may not even...
There are multiple issues here. First, Babelfish does not currently support variable assignments whereby the target variable also occurs in the assignment expression. This is a known issue. Incidentally, the...
We are tracking this internally at AWS.
Functions PERCENTILE_DISC and PERCENTILE_CONT are not supported in the T-SQL syntax, which requires both WITHIN GROUP and OVER. They work fine in native PostgreSQL when the OVER clause is omitted,...
This is a known issue, related to the result of certain expressions not being deterministic in SQL Server, which does not map well to PG. As a workaround, a trigger...