Question: PL / pgSQL is a block - structured language. The complete text of a function body must be a block. A block is defined as:

PL/pgSQL is a block-structured language. The complete text of a function body must be a block. A block is defined as:
[<< label >>]
[ DECLARE
declarations ]
BEGIN
statements
END [ label ];
When do you require the optional label inside angle brackets (or guillets - double chevrons [<<>>]) in a PL/pgSQL program (more than one answer possible)??
Group of answer choices
Always
When you want to identify the block for use in an EXIT statement
When you want to qualify the block for variable use
Only when you want to qualify the block for variable use in a DO-block
Never

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!