© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2024
H. Dombrovskaya et al.PostgreSQL Query Optimizationhttps://doi.org/10.1007/979-8-8688-0069-6_12

12. Functions

Henrietta Dombrovskaya1  , Boris Novikov2 and Anna Bailliekova3
(1)
DRW Holdings, Chicago, IL, USA
(2)
Database expert, Helsinki, Finland
(3)
UrbanFootprint, Milwaukee, Wisconsin, USA
 

This chapter focuses on the most underused and misused features of PostgreSQL, objects—functions. Since all modern programming languages include user-defined functions, people often assume that database functions are cut from the same cloth and if you know how and when to write functions in an application programming language, you can apply this directly to PostgreSQL. This ...

Get PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries 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.