Re: [Plproxy-users] A complex plproxy query

Hannu Krosing wrote:
> On Thu, 2009-01-22 at 15:10 +0300, Igor Katson wrote:
>
>
>> Ok, thank you, guys. What is the best way to make an array out of a
>> column? I didn't make up anything better then writing a function:
>>
>> CREATE OR REPLACE FUNCTION int_column_to_array(query text) RETURNS int[]
>> AS $$
>> DECLARE
>> arr int[];
>> rec int;
>> BEGIN
>> FOR rec IN EXECUTE query
>> LOOP
>> arr := array_append('{}',rec);
>> END LOOP;
>> RETURN arr;
>> END;
>> $$ language plpgsql;
>>
>
> hannu=# select ARRAY(select usename from pg_user);
> ?column?
> -------------------------------
> {postgres,hannu,m1,skyncuser}
> (1 row)
>
>
>
>
Lots of thanks! I tried the same one, but with ARRAY[], so i didn't get
anything.