[prev] 45 [next]

PostgreSQL Functionality (cont)

PostgreSQL stored procedures differ from SQL standard:
  • only provides functions, not procedures (but functions can return void)
  • allows function overloading (same function name, diff argument types)
  • defined at different "lexical level" to SQL
  • provides own PL/SQL-like language for functions