News for hackers. Stuff that matters.
Re:PostgreSQL vs SQL Server installation Faceoff by jawngee on Monday May 31, 2010 @11:47AM (#1392733)
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.

Re:PostgreSQL vs SQL Server installation Faceoff by fnid2 on Monday May 31, 2010 @01:22PM (#1392981)
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.

Re:PostgreSQL vs SQL Server installation Faceoff by jawngee on Thursday June 10, 2010 @11:40PM (#1422683)
What do offset and limit have to do with presentation?