SQL Server T-SQL To GreenPlum PostgreSQL Syntax Cheat Sheet

Here's a quick translation from SQL Server's T-SQL to Pivotal's MPP GreenPlum PostgreSQL for some of the most commonly used syntax (i.e. here's the stuff I've tripped over while moving from SQL to GreenPlum/Postgres) .   SQL Server - TOP SELECT TOP 100 * FROM MyTable Corresponding PostgreSQL - LIMIT SELECT * FROM my_table LIMIT… Continue reading SQL Server T-SQL To GreenPlum PostgreSQL Syntax Cheat Sheet