Everything About ___
Live briefing

Everything about SQL/PSM

SQL extension

SQL/PSM is an ISO standard mainly defining an extension of SQL with a procedural language for use in stored procedures. Initially published in 1996 as an extension of SQL-92, SQL/PSM was later incorporated into the multi-part SQL:1999 standard, and has been part 4 of that standard since then, most recently in SQL:2023. The SQL:1999 part 4 covered less than the original PSM-96 because the SQL statements for defining, managing, and invoking routines were actually incorporated into part 2 SQL/Foundation, leaving only the procedural language itself as SQL/PSM. The SQL/PSM facilities are still optional as far as the SQL standard is concerned; most of them are grouped in Features P001-P008. Wikipedia →

🧭 Start here: a 6-step reading path

  1. Read the overview: SQL/PSMA 5-minute orientation
  2. Pick up a classic book: Understanding SQL's stored proceduresThe most-reprinted book on the subject
  3. Go sideways: SQL/JRTA closely related topic
  4. Go sideways: PL/pgSQLA closely related topic

📖 Definitions

No dictionary entry for this exact phrase.

🗂️ The subject at a glance

No outline available.

🏆 Landmark papers (most cited)

📚 Books worth reading

Ranked by number of editions on Open Library, a rough measure of how lasting a book is.

🔗 Related topics