Re: joining a table whose name is stored in the primary record

Andreas Kretschmer wrote:
> create or replace function zip_foo(OUT out_id int, OUT out_name text, OUT out_name2 text) returns setof record as $$
> declare
> my_rec RECORD;
> my_name TEXT;
> begin
> for my_rec in select id, name, parent_tbl, parent_id from zip LOOP
> execute 'select name from ' || my_rec.parent_tbl || ' where id = ' || my_rec.parent_id || ';' into my_name;
> out_id := my_rec.id;
> out_name := my_rec.name;
> out_name2 := my_name;
> return next;
> end loop;
> end;
> $$ language plpgsql;
>
Thanks, Andrew. I was hoping for a pure SQL solution but your idea will
certainly work.

John