Postgres Pro
Downloads
Home   >   mailing lists

Thread: Pgsql problem

Pgsql problem

From
pasman pasmański
Date:
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

Re: Pgsql problem

From
Dmitriy Igrishin
Date:
Hey pasman,

2012/1/12 pasman pasmański <pasman.p@gmail.com>
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 ?
Presently, hstore is a most flexible solution in such cases.
See http://www.postgresql.org/docs/9.1/static/hstore.html

--
// Dmitriy.


Re: Pgsql problem

From
Achilleas Mantzios
Date:
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

Re: Pgsql problem

From
pasman pasmański
Date:
Thanks.

Hstore works perfectly.



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