select result into string's array
| От | Alberto Asuero Arroyo |
|---|---|
| Тема | select result into string's array |
| Дата | |
| Msg-id | 4ACEE6A3.4090901@gmail.com обсуждение исходный текст |
| Ответы |
Re: select result into string's array
Re: select result into string's array |
| Список | pgsql-sql |
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,
В списке pgsql-sql по дате отправления: