All I have to say about PostgreSQL vs SQL Server is LIMIT ... OFFSET.
I've been porting a SQL Server app over to PostgreSQL, but in the meantime having to maintain the SQL Server one. The lack of LIMIT/OFFSET in SQL Server is maddening.
I've been porting a SQL Server app over to PostgreSQL, but in the meantime having to maintain the SQL Server one. The lack of LIMIT/OFFSET in SQL Server is maddening.
Not that I think OFFSET and LIMIT belong in SQL (IIRC, ANSI folks agree). It's a query language, not a presentation one.