Procedural Programming with PostgreSQL PL/pgSQL: Design Complex Database-Centric Applications with PL/pgSQL

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

B. Shaik, D. K. ChemuduruProcedural Programming with PostgreSQL PL/pgSQLhttps://doi.org/10.1007/978-1-4842-9840-4_9

9. Custom Operators

Baji Shaik¹   and Dinesh Kumar Chemuduru²

(1)

Texas, TX, USA

(2)

Andhra Pradesh, India

 

In the previous chapter, we talked about cursors and how to use them in PL/pgSQL with some examples. In this chapter, we will start with what are different types of built-in operators available in PostgreSQL. We will cover custom operators and their purpose. We will walk through the use cases to create custom operators with simple examples. We will also explain the advantages and disadvantages of having custom operators. By the end of this ...