Information about SQL in general should not be confused with information about specific RDBMS. That SE answer is about MS SQL Server. What I wrote was specifi

Information about SQL in general should not be confused with information about specific RDBMS. That SE answer is about MS SQL Server. What I wrote was specific to PostgreSQL which does a specific weird thing using CTEs where they are materialized. In SQL Server, CTEs are not materialized and are just used to organize the query, to make it more readable. If I wrote about PostgreSQL heap organized tables, would you object and say I'm wrong because MS SQL Server tables are index-organized, clustered on the primary key?