4 ms·
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 main
by jawngee 16y ago
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.
- fnid2 16y agohttp://stackoverflow.com/questions/187998/row-offset-in-ms-sql-server http://stackoverflow.com/questions/187998/row-offset-in-ms-s...
- rbanffy 16y agoSQL 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.
- jawngee 16y agoWhat do offset and limit have to do with presentation?