A. Kretschmer wrote:
> In response to Igor Katson :
>
>> I think I need a built-in function to make a column from an array, like
>> in the backwards operation SELECT ARRAY(column)
>>
>
> By David Fetter:
>
> CREATE OR REPLACE FUNCTION unnest(ANYARRAY) RETURNS SETOF ANYELEMENT
> LANGUAGE SQL AS $$SELECT $1[i] FROM
> generate_series(array_lower($1,1),array_upper($1,1)) i;$$;
>
> HTH, Andreas
>
Thanks. I thought, there is a built-in one for that.
