Re: Substitute a variable in PL/PGSQL.

Merlin Moncure wrote:

>On Wed, Jul 23, 2008 at 4:08 AM, Klint Gore <kgore4@une.edu.au> wrote:
>
>
>here is a way to do it with record variables...no inner loop but
>doesn't the column names.  with a little work you could add those with
>some queries to information_schema (i don't think it's worth it
>though).
>
>create or replace function ff(tablename text) returns setof text as
>$$
>  declare
>    r record;
>  begin
>    for r in
>      execute 'select record_out(' || tablename || ') as f' ||
>        ' from ' || tablename loop
>      return next r.f;
>    end loop;
>  end;
>$$ language plpgsql;
>
>merlin
>
>
>
Hi Merlin,

Where can I find out more on the record_out function?

Steve M.