[Solved] Consider this PL/pgSQL snippet:DECLARE total integer := 10; BEGIN total := total * 2; RAISE NOTICE '%', total; END;What will be printed? | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

Consider this PL/pgSQL snippet:

DECLARE
  total integer := 10;
BEGIN
  total := total * 2;
  RAISE NOTICE '%', total;
END;

What will be printed?

A10

BError

C20

D0

Step-by-Step Solution

Solution:

Quick Trick: Assignment updates variable value immediately [OK]

Common Mistakes:

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Consider this PL/pgSQL snippet: