How to exit from plpgsql function while returning query

Question

In a plpgsql function how can I return a query and return from the function itself? If I just do return query select ... the statement after gets executed as well, so the return doesn't actually return from the whole function?

klin · Accepted Answer · 2018-10-13 12:25:03Z

4

Use just return; as a single statement, example:

create or replace function my_func()
returns setof int language plpgsql as $$
begin
    return query select generate_series(1,2);
    return;
    return query select generate_series(3,4);
end $$;

select my_func();

 my_func 
---------
       1
       2
(2 rows)

answered Oct 13, 2018 at 12:25

klin

123k15 gold badges241 silver badges263 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to exit from plpgsql function while returning query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related