Re: [Plproxy-users] A complex plproxy query

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)

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