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