Обсуждение: Pgsql problem

Hi.

I write function in pgsql. This function needs
to execute other functions by name.
I do it using loop:

declare r record;
begin
for r in execute 'select ' || $1 || '()'
  loop
  end loop;

But I can't convert a record to array of text.
How to do it ?


------------
pasman

On Πεμ 12 Ιαν 2012 12:51:00 pasman pasmański wrote:
> Hi.
>
> I write function in pgsql. This function needs
> to execute other functions by name.
> I do it using loop:
>
> declare r record;
> begin
> for r in execute 'select ' || $1 || '()'
>   loop
>   end loop;
>
> But I can't convert a record to array of text.
> How to do it ?
>

Maybe you should a look at array_agg. It is an aggregate function operating on
a set of values and returning the resulting array.

http://www.postgresql.org/docs/9.0/interactive/functions-aggregate.html


>
> ------------
> pasman

--
Achilleas Mantzios
IT DEPT

Thanks.

Hstore works perfectly.



------------
pasman