pl/pgsql frustration

[John Wells <jb@xxxxxxxxxxxxxxxxxxxxx>]

Guys,

I'm trying to write a simple function that will return a table's actual
row count on PostgreSQL 7.4.  I've tried two different versions (see
below), both with the same result:

"ERROR:  syntax error at or near "select" at character 127"

I've also tried a cursor example found in the interactive 7.4 docs and
get a similar 'select' error.  Am I missing something here or is
something else going on?  Thanks for any help you can provide.

John
----
create or replace function count_rows (text) returns integer as '
declare   
  return_val int4;  
  curs1 refcursor;
  table_name ALIAS FOR $1;
begin
	OPEN curs1 FOR EXECUTE 'select * from ' || quote_indent(table_name);

	fetch curs1 into return_val;
	close curs1;
end;
' language 'plpgsql';

create or replace function count_rows (text) returns integer as '
declare   
  return_val int4;  
  curs1 cursor FOR EXECUTE 'select count(*) from ' ||
quote_indent(table_name);
  table_name ALIAS FOR $1;
begin
	OPEN curs1;
	fetch curs1 into return_val;
	close curs1;
end;
' language 'plpgsql';


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster