Re: [Plproxy-users] A complex plproxy query - Mailing list pgsql-general

On Thu, 2009-01-22 at 16:13 +0200, 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)

So what yo need is

select * from
gather_friend_info_from_all_partitions(get_friend_id_list_form_user_partition(user_id));

--
------------------------------------------
Hannu Krosing   http://www.2ndQuadrant.com
PostgreSQL Scalability and Availability
   Services, Consulting and Training