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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
