Fun with Functions - by Example by Joe Conway

Wednesday November 16, 1:20-2:15


One of the key strengths of PostgreSQL is its extensibility, and at the core of that are functions. In PostgreSQL functions can be used as an end in-and-of themselves, or they can be used to allow the creation of other custom SQL objects such as operators and aggregates.

This presentation will enlighten the audience on the vast array of capabilities embodied in PostgreSQL functions, and illustrate many of the key features through simple and real world examples. Specifically it covers:

  • What are functions and how are they used within PostgreSQL
  • What types and languages of functions can be created
  • Variations and options for arguments
  • Variations and options for return values
  • Function attributes in detail

Along the way are many examples are presented to aid learning, and the talk concludes with a section providing more complex and real world examples.

About the speaker

Joe Conway is an innovative leader with broad experience in a wide array of disciplines and extensive international business exposure. He has been involved with PostgreSQL as a user since 1998, and a contributor since 2001. He is also the author and maintainer of a PostgreSQL procedural language handler for the R language, PL/R. Joe is currently VP PostgreSQL Engineering for Crunchy Data Solutions​

Thursday, October 13, 2016 - 12:15