Chapter 8. Advanced SQL

SQL is a language that has been designed to perform complex queries. No matter what kind of query you have to write, in most cases you can easily do it with SQL.

PostgreSQL provides a rich set of SQL commands, and it is the perfect database for nearly all kinds of complex operations. Even if you want to work with complex integrity constraints such as inheritance, PostgreSQL will provide the right solution for you.

In this chapter, you will be guided through PostgreSQL's advanced SQL capabilities and you will learn to develop complex and powerful data structures. You will need this information when building sophisticated PHP applications with the help of PostgreSQL.