Re:PostgreSQL vs SQL Server installation Faceoff
by rbanffy on Monday May 31, 2010 @05:26PM
(#1393544)
SQL queries are seldom considered examples of neatness, but the top solution (which is a good one, as far as my rusty TSQL allows me to judge) is a textbook example of a kludge.
Not that I think OFFSET and LIMIT belong in SQL (IIRC, ANSI folks agree). It's a query language, not a presentation one.
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.