In this chapter, we will discuss some SQL features supported by PostgreSQL, that were not covered in the previous chapters. Some advanced techniques will also be described.
The same sample database as was used in the previous chapters is used in the code examples. It is recommended to recreate the sample database in order to get the same results as shown in the examples.
In this chapter, we are going to cover the following topics:
The code examples in this chapter are based on the car portal database described in the previous chapters. The scripts for creating the database and filling it with data (