When writing PL/pgSQL functions, the syntax highlighting stops working inside the function body if it is defined using the standard PostgreSQL syntax with AS ...
PL/pgSQL, as a fully featured programming language, allows much more procedural control than SQL, including the ability to use loops and other control structures. SQL statements and triggers can call ...