From: | Hannu Krosing <hannu(at)2ndQuadrant(dot)com> |
---|---|
To: | Igor Katson <descentspb(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org, plproxy-users(at)pgfoundry(dot)org |
Subject: | Re: [Plproxy-users] A complex plproxy query |
Date: | 2009-01-22 14:22:48 |
Message-ID: | 1232634168.8196.3.camel@huvostro |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Euler Taveira de Oliveira | 2009-01-22 14:24:25 | Re: deductive databases in postgreSQL |
Previous Message | Igor Katson | 2009-01-22 14:16:46 | Re: [Plproxy-users] A complex plproxy query |