Postgresql save query result in 2d array

Question

I would like to create 2d array inside a function and populate it with values from select statement. I try this code and end up with one-dimension array. What am I doing wrong?

select array(select a from t a)
=====================================
"{"(1,stxt,varchar)","(2,sint,int)"}"


create or replace function __test(
) returns text
language 'plpgsql' as
$$
declare
  _dat varchar[][];

begin

  _dat = (select array(select a from t a));

  return array_dims(_dat);

end;
$$;


select __test();
===========
"[1:2]"

I expected last command to return [1:2][1:3] for two rows of three columns.

Pavel Stehule · Accepted Answer · 2012-05-07 14:19:25Z

1

PostgreSQL support only one type arrays - so you can take only array of row / you can't to take 2D array what you would. There are no way how to do it well now.

answered May 7, 2012 at 14:19

Pavel Stehule

46.6k6 gold badges103 silver badges102 bronze badges

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

Collectives™ on Stack Overflow

Postgresql save query result in 2d 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