Crowdly

Add to Chrome

Which of the following is the correct syntax for creating function/stored proced...

✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.

Which of the following is the correct syntax for creating function/stored procedure in PostgreSQL?

CREATE PROC proc_name() AS && SELECT * FROM table_name;$$

❌

CREATE FUNCTION func_name() RETURNS VOID AS  LANGUAGE plpgsql;

✅

CREATE PROCEDURE proc_name AS SELECT * FROM table_name;

❌

CREATE FUNCTION func_name() RETURNS VOID AS  LANGUAGE plpgsql;

❌

More questions like this

Want instant access to all verified answers on softserve.academy?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Terms of Use Contact Us