Re: Returns setof record PG/PLSQL

On Sun, 2005-08-14 at 20:53 -0400, Tom Lane wrote:
> regression=# create type table_count_result as (table_name text, count bigint);
> CREATE TYPE
> regression=# create or replace function generate_table_count ()
> regression-# returns setof table_count_result as $$
> regression$# declare
> regression$# tname record;
> regression$# count table_count_result;
> regression$# begin
> regression$# for tname in select table_name from information_schema.tables
> regression$# where table_schema = 'public' loop
> regression$# for count in execute 'select ' || quote_literal(tname.table_name) || ', count(*) from ' || quote_ident(tname.table_name) loop
> regression$# return next count;
> regression$# end loop;
> regression$# end loop;
> regression$# return;
> regression$# end$$ language plpgsql;
> CREATE FUNCTION
> regression=# select * from generate_table_count();

Sweet mercy...success. Thanks...my forehead was a bit bloody from all
the head bashing going on over here...

I have much to learn about pl/pgsql programming!

Thanks again!
John