Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id B6BEA633041
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri,  9 Oct 2009 04:31:01 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 51232-09 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri,  9 Oct 2009 07:30:54 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.152])
	by mail.postgresql.org (Postfix) with ESMTP id 046DD632887
	for <pgsql-sql@postgresql.org>; Fri,  9 Oct 2009 04:30:53 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 22so216859fge.1
	for <pgsql-sql@postgresql.org>; Fri, 09 Oct 2009 00:30:51 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from
	:user-agent:mime-version:to:subject:content-type
	:content-transfer-encoding;
	bh=rG6ZFmBvtPcvDH/RCkY612dXQxRvXHfV/QWqKnCxunQ=;
	b=yAFCv5J4cvuZo6Orc480rWBx8Y/AyQ35vcEsRnndOwqV9MKsEYa3hK8/v3Ly98fx7T
	zFxlWzoUWi8/8GXK2ZsnEamCz9B9ZzYx+T3bcEXTxJyKLzsxFvgkvqBeqTrzHGwYtmtk
	/kBZnFEHHdUcdTp6/Hyat+2w+7GxI6xFZg6mc=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject
	:content-type:content-transfer-encoding;
	b=I7oo/gGOLg+THqfZgXWlNWg+x7Db+Vz60DFK/9G5V6iSB6Cb//CQMgUH592q3UALdA
	HL46rNKsfUJmgO6tdgj/QcHUpNMfikVKe8GSJK7fzIVnewgj6/XFTIhWbHai+aZA4vvL
	EATYrYk3hupASAXNNwrVjLZYGfDs2rXsd6aYE=
Received: by 10.86.234.9 with SMTP id g9mr2084730fgh.39.1255073451825;
	Fri, 09 Oct 2009 00:30:51 -0700 (PDT)
Received: from ?10.30.102.23? (100.Red-80-37-140.staticIP.rima-tde.net
	[80.37.140.100])
	by mx.google.com with ESMTPS id d4sm1665034fga.19.2009.10.09.00.30.50
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Fri, 09 Oct 2009 00:30:51 -0700 (PDT)
Message-ID: <4ACEE6A3.4090901@gmail.com>
Date: Fri, 09 Oct 2009 09:30:43 +0200
From: Alberto Asuero Arroyo <albertoasuero@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: select result into string's array
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 200910/30
X-Sequence-Number: 33229

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,