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.

Get PHP and PostgreSQL: Advanced Web Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.