[Solved] Why does this function declaration cause an error?CREATE FUNCTION test_func(VARIADIC nums int) RETURNS int AS $ SELECT sum(nums); $ LANGUAGE sql; | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

Why does this function declaration cause an error?

CREATE FUNCTION test_func(VARIADIC nums int) RETURNS int AS $$
  SELECT sum(nums);
$$ LANGUAGE sql;

AVARIADIC keyword cannot be used in SQL language functions

BFunction body syntax is incorrect

Csum() cannot be used inside functions

DVARIADIC parameter must be declared as an array type

Step-by-Step Solution

Solution:

Step 1: Check VARIADIC parameter type
VARIADIC parameters must be declared as arrays, but here it is declared as int (scalar).
Step 2: Identify error cause
This mismatch causes a syntax error when creating the function.
Final Answer:
VARIADIC parameter must be declared as an array type -> Option D
Quick Check:
VARIADIC parameter type error = array required [OK]

Quick Trick: VARIADIC must be array type, not scalar [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does this function declaration cause an error?