PostgreSQL: Accessing data of RECORD type in a plpgsql function

Question

This is my first function:

CREATE  FUNCTION func1(INOUT a  integer,OUT b integer,  OUT c float, OUT   d integer,OUT e decimal)
 AS  $BODY$
DECLARE

BEGIN
.
.
.   
END
$BODY$
LANGUAGE plpgsql VOLATILE

Output is:

$ SELECT * FROM func1(242);

a | b | c | d | e
--+--+--+--+---

242 | 5 | 7.5 | 15 | 1.2208

And this is second function:

CREATE  FUNCTION func2()
   AS  $BODY$
DECLARE
   d  RECORD;

BEGIN
    EXECUTE 'SELECT * FROM func1(242)' INTO d;  
    raise notice 'arr: %', d;.  -– output is->  NOTICE:  arr: (242,5,7.5,15,1.2208)
--HERE I want access to a,b,....
    .
    .   
END
$BODY$
LANGUAGE plpgsql VOLATILE

How I can access separately to a,b,c,d and e variables inside func2.

perzsa · Accepted Answer · 2016-05-17 12:02:04Z

1

Here's one solution:

FOR d in EXECUTE 'SELECT * FROM func1(242)'
LOOP
  --here you can access them, or assign them to a local variable
  raise notice 'a:%, b:%, c:%, d:%, e:%', d.a, d.b, d.c, d.d, d.d, d.e;
END LOOP;

answered May 17, 2016 at 12:02

perzsa

2914 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

PostgreSQL: Accessing data of RECORD type in a 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