how to store multiple values in single variable in postgresql

Question

I want to store multiple values in single variable(array) in postgresql stored procedure.

My query in mysql is as

select name from cloud_table into @cloud; // @cloud contain multiple name

I want to convert this query into Postgresql. how to achieve this.

How about using a temporary table instead? select name from cloud_table into #cloud ? Please edit your post and show us how that variable will be used later on. — Corion
– Corion, Commented Jan 7, 2019 at 13:12
I want to sent multiple cloud name(array) to a function for further operation — Ashish
– Ashish, Commented Jan 7, 2019 at 13:15

user330315 · Accepted Answer · 2019-01-07 13:15:09Z

3

You can store all values in an array.

Something like:

.... 
declare
   l_names text[];
begin
   ...
   select array_agg(name) 
       into l_names
   from cloud_table;

   -- pass the array to a function
   perform some_function(l_names);

   ...
end;

If you already have a function that accepts an array as a parameter and you want to pass the result of your select as an array, you can use:

select your_function(array(select name from cloud_table));

answered Jan 7, 2019 at 13:15

user330315

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

Collectives™ on Stack Overflow

how to store multiple values in single variable in postgresql

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