Chapter 131 of 1963 min read
Lesson 14.2 β Writing a Stored Procedure in PostgreSQL (PL/pgSQL)
𧬠Biological Scenario: "Register a new sample for a patient, and automatically flag if this pushes their total sample count over 5" combines a write, a check, and conditional logic β exactly the kind of multi step taskβ¦
Sign in to read this
βLesson 14.2 β Writing a Stored Procedure in PostgreSQL (PL/pgSQL)β is for subscribers. Start with a free account β it takes a name and an email β then subscribe for $1 a month to open it.
- Python and R courses free in full
- First two chapters of every other course