[SQL] select result into string's array

[Alberto Asuero Arroyo]

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,



-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql