DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	b=QjtSTqbSPDQpQc+v8F/iwTw/wu/+sxvUYTxa8XFH7AvFUrFfnQ89dkE6/J4Ssq5eo+
	slm8fz/47fVis18cWg73orq2wW2Ae7G6lSDIAPA82ne3IyiC7Lgl1fyxiLsMUcCsNV8O
	ULRPneDIIOelLult/wJ3ccjegfJOIIFj2siZo=
Message-ID: <4ACEFDA4.60102@gmail.com>
Date: Fri, 09 Oct 2009 11:08:52 +0200
From: Alberto Asuero Arroyo <albertoasuero@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
To: Dmitriy Igrishin <dmitigr@gmail.com>
CC: pgsql-sql@postgresql.org
Subject: Re: select result into string's array
References: <4ACEE6A3.4090901@gmail.com>
	<b4399d110910090131h425602ack6fe6ae8661a975a3@mail.gmail.com>
In-Reply-To: <b4399d110910090131h425602ack6fe6ae8661a975a3@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Dmitriy Igrishin wrote:
> Hello.
>
> You should use an array constructor:
>
> DECLARE
>     m_array text[];
>     [..]
> BEGIN
> FOR m_array IN SELECT ARRAY[col_1, col_2, col_N] FROM my_table LOOP
> [..]
> END LOOP;
>
> Regards,
> Igrishin Dmitriy.
>
> 2009/10/9 Alberto Asuero Arroyo <albertoasuero@gmail.com
> <mailto:albertoasuero@gmail.com>>
>
>     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
>     <mailto:pgsql-sql@postgresql.org>)
>     To make changes to your subscription:
>     http://www.postgresql.org/mailpref/pgsql-sql
>
>


It's has been really useful for my  to solve the dinamic Record
Introspection problem that I had.

Thanks,

Alberto