Talk Information
Writing Basic Postgres Functions


Location
Date
12-03-2013 07:00 PM
Presenter
Lloyd Albin
Description

In the first half of this presentation we talk about some of the function options and how they affect your functions.

In the second half of this presentation I show you how to write some basic functions:

  • Converting between field types that postgres does not support.
  • Indexing the results of a function instead of a field.
  • Writing a Shadow table using a trigger function
  • Writing a Hidden table that the user does hot have access to.
  • Returning multiple rows of data.
Documents