Re: Pgsql problem - Mailing list pgsql-general

From Dmitriy Igrishin
Subject Re: Pgsql problem
Date
Msg-id CAAfz9KNdumBAN6zY4pBiDFrocqrfEzXueDqiNffSwncb4TMrHw@mail.gmail.com
Whole thread Raw
In response to Pgsql problem  (pasman pasmański <pasman.p@gmail.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: pasman pasmański
Date:
Subject: Pgsql problem
Next
From: seiliki@so-net.net.tw
Date:
Subject: unnest array of row type