PostgreSQL

SQL ConstantCare® uses PostgreSQL as a back end – specifically, AWS RDS Aurora – so I’ve spent a lot of time writing Postgres queries lately. Here are some of the things I’ve noticed that are different. CTEs are optimization fences. In SQL Server, if you write this query: Transact-SQL With AllPosts AS (SELECT * FROM StackOverflow.dbo.Posts)…