© Henrietta Dombrovskaya, Boris Novikov, Anna Bailliekova 2021
H. Dombrovskaya et al.PostgreSQL Query Optimizationhttps://doi.org/10.1007/978-1-4842-6885-8_11

11. Functions

Henrietta Dombrovskaya1  , Boris Novikov2 and Anna Bailliekova3
(1)
Braviant Holdings, Chicago, IL, USA
(2)
HSE University, Saint Petersburg, Russia
(3)
Zendesk, Madison, WI, USA
 

This chapter focuses on the most underused and misused 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 to write functions and when to write functions in an application programming language, you can apply this knowledge to PostgreSQL. This could not be further from ...

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.