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,