postgres function returning array

Question

I have the following function (using postgres 9.4)

create or replace function toto()  RETURNS text[] AS $$
  DECLARE
    threed text[];
  BEGIN
    select array (select tata from hello)  into threed;
    raise notice 'HERE %',threed;
    return threed;
  END;
$$ LANGUAGE plpgsql;

No problem on creation, I ran the function in psql and I get:

 select from toto();
 NOTICE:  HERE {055,056,057,058,059}
 --
 (1 row)

The notice displays the correct results. What I do not understand is why the results themselves are not displayed ? Where am I wrong ? Thanks for any pointer and help

For me UNNEST did the trick SELECT * FROM UNNEST(toto()) — Camille
– Camille, Commented Jul 29, 2021 at 7:48

Pat070 · Accepted Answer · 2017-03-06 17:55:09Z

2

Sorry stupid error I was calling the function as select toto() instead of select * toto();

took me a day to find out :(

answered Mar 6, 2017 at 17:55

Pat070

3351 gold badge4 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

postgres function returning array

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