Writing Advanced PostgreSQL Functions

What we are going to cover

  • Function Basics
    • Procedural Languages
    • Function Behavior
    • NULL INPUT
    • Security
    • Syntax
    • Inline (Function) Syntax
  • Basic Example Functions
    • Functional Indexes
    • Real World Example of Functional Indexes
    • Case Insensitive Indexes
  • Advanced Functions
    • Working with View Definitions
  • Debugging Functions
    • Debugging your Function