PostgreSQL - PL/pgSQL Fundamentals
Which clause specifies the return type of a function in PostgreSQL?
Which clause specifies the return type of a function in PostgreSQL?
easy📝 Conceptual Q2 of 15
Step-by-Step Solution
Solution:
Step 1: Identify the clause for function return type
In PostgreSQL, theRETURNSclause defines the data type the function will return.Step 2: Validate other options
Options B, C, and D are not valid PostgreSQL syntax for specifying return types.Final Answer:
RETURNS -> Option BQuick Check:
Return type clause = RETURNS [OK]
Quick Trick: Use RETURNS to define function output type [OK]
Common Mistakes:
- Using OUTPUT instead of RETURNS
- Omitting the RETURNS clause
Master "PL/pgSQL Fundamentals" in PostgreSQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore PostgreSQL Quizzes