Return multiple rows from plpgsql function

Question

I have the below function:

CREATE OR REPLACE FUNCTION function1() RETURNS TABLE(foo1 VARCHAR, foo2 VARCHAR) AS $$
    BEGIN
    RETURN QUERY SELECT e.col1, e.col2 FROM my_table e;
    END;
$$ LANGUAGE plpgsql;

It returns something like this:

function1
record
|--------------|
(a,b)
(c,d)

But I'm expecting a result analog to a query like this:

SELECT e.col1, e.col2 FROM my_table e;

  col1  col2
|-----|-----|
   a     b
   c     d

Because I want to execute the function a get the separates columns values in a java resultSet and iterate accros them. Thanks!

possible duplicate of RETURN QUERY-Record in PostgreSQL

Erwin Brandstetter
– Erwin Brandstetter

2013-09-09 15:06:53 +00:00
Commented Sep 9, 2013 at 15:06 — Erwin Brandstetter
– Erwin Brandstetter, Commented Sep 9, 2013 at 15:06

segasai · Accepted Answer · 2013-09-01 00:22:27Z

5

You need to do

select * from function1();

answered Sep 1, 2013 at 0:22

segasai

8,5581 gold badge31 silver badges40 bronze badges

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

Collectives™ on Stack Overflow

Return multiple rows from plpgsql function

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