Hi,
I need to store the result of select into an array of string:
/create or replace function search_engine.test/
/(/
/)/
/ returns integer as $$/
/declare/
/ m_array text[];/
/begin/
/ for m_array in select * from my_table loop/
/ raise notice 'valor 1: %',m_array;/
/ end loop;/
/ return 1;/
/end; $$ LANGUAGE plpgsql;/
This launch this errors:
/ERROR: array value must start with "{" or dimension information
SQL state: 22P02
Context: PL/pgSQL function "test" line 4 at FOR over SELECT rows/
Is it possible do this?? May I choose another way?
Thanks in advance
Alberto,