Using a tablename as a parameter to a function.

Hi there,

Is it possible (legal syntax, I mean) to pass a tablename
as a parameter to a function?

I don't know if its impossible or just that my plpgsql code is
not up to scratch.

Don't laugh, I'm just starting! :)

Thanks for any pointers anyone can give.

steve

=======================================================================

drop function testfunc( text );

create function testfunc( text ) returns int
as
'
declare
rowcount int := 0;

tablename alias for $1;

begin

-- ----------------------------------------------------------
-- Report on the number of entries in the table.
-- ----------------------------------------------------------

select into rowcount count(*) from tablename;

return rowcount;

end;
'
language 'plpgsql';

select testfunc( 'MyTable' );
select testfunc( 'ATable' );
select testfunc( 'BigTable' );