using raise info to display array element - Mailing list pgsql-general

From Kiryl Mauryshchau
Subject using raise info to display array element
Date
Msg-id CAKFAgEhPOhSwbc1JQNGqM805dB+nWzHiY3Y4xQ7ZSgJz=PWKAQ@mail.gmail.com
Whole thread Raw
Responses Re: using raise info to display array element
List pgsql-general
I am trying to print values of an array one by one, but it doesn't work.

For example, if i want to print entire array at once, it does work:

CREATE OR REPLACE FUNCTION "public"."test_func" () RETURNS integer AS
$body$
declare
  i int;
  v_arr integer[] = '{0, 1}';  
begin

  v_arr[1] := 5;
  v_arr[2] := 7;
 
  raise info 'entire array: %', v_arr;
 
  return 0;

end
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

But then if I try this:

CREATE OR REPLACE FUNCTION "public"."test_func_new" () RETURNS integer AS
$body$
declare
  i int;
  v_arr integer[] = '{0, 1}';  
begin

  v_arr[1] := 5;
  v_arr[2] := 7;
 
  raise info '1st element: %', v_arr[1];
 
  return 0;

end
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

.. and it doesn't compile.

Can someone help me? Thanks!

--
Regards,
Kiryl Mauryshchau

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Temp table visibility
Next
From: Pavel Stehule
Date:
Subject: Re: using raise info to display array element