select result into string's array - Mailing list pgsql-sql

From Alberto Asuero Arroyo
Subject select result into string's array
Date
Msg-id 4ACEE6A3.4090901@gmail.com
Whole thread Raw
Responses Re: select result into string's array  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: select result into string's array  (Dmitriy Igrishin <dmitigr@gmail.com>)
List 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 by date:

Previous
From: Lennin Caro
Date:
Subject: Re: Pulling additional columns with aggregate
Next
From: "A. Kretschmer"
Date:
Subject: Re: select result into string's array