There are some use cases for which plain SQL might not be enough; you need to use recursion, but don’t know how. Common Table Expressions may be able to help!
In this session, we will use PostgreSQL to introduce the attendees to Common Table Expressions. We will go over their syntax, view their results, and discuss best practices and use cases for this powerful SQL feature.
Michael Brewer is an Application Programmer Specialist for the Franklin College Office of Information Technology at The University of Georgia. He designs database-backed web applications used by thousands of students and faculty and serves on several college and University-wide committees on Web development, best practices, and application security. In 2005, he won an Advising Technology Innovation Award from the National Academic Advising Association for an academic advising application he created and maintains. A speaker at OSCON in 2011 and 2012, he is also on the board of the United States PostgreSQL Association. He holds dual degrees in Mathematics and Music from The University of Georgia. A member of ASCAP, he also conducts the oldest continually operating community band in the state of Georgia; he has arranged music for orchestra, band, chorus, and has even composed incidental music for plays and musicals.
For exhibition and sponsorship opportunities, contact Sharon Cordesse at firstname.lastname@example.org
For information on trade opportunities with O'Reilly conferences contact email@example.com
For media-related inquiries, contact Maureen Jennings at firstname.lastname@example.org
View a complete list of OSCON contacts