News for hackers. Stuff that matters.
Re:Modern SQL in PostgreSQL by Vivtek on Sunday February 08, 2015 @06:17PM (#9018995)
Second that request. What can I read to go beyond my SELECT * from t order by c-level knowledge?
Re:Modern SQL in PostgreSQL by AlisdairO on Sunday February 08, 2015 @06:48PM (#9019075)
Apologies for the self-plug, but you might find some stuff in the later-stage Aggregates and Recursive exercises on http://pgexercises.com . There's a bunch of stuff on CTEs and window functions in there.
Re:Modern SQL in PostgreSQL by jklowden on Sunday February 08, 2015 @11:34PM (#9019751)
I like Date's SQL and Relational Theory (http://shop.oreilly.com/product/0636920022879.do). It won't tell you about the latest changes to the standard, but it will help you get a handle on the relational model, which is the key to using SQL intelligently.