On Thu, Jul 07, 2005 at 12:22:38PM -0600, Clark Allan wrote: > Here is an example of what i would like to do... > --------------------------------------- > CREATE FUNCTION fun_totalrecords(varchar) RETURNS int8 AS' > DECLARE > theTable ALIAS FOR $1; > result int := 0; > BEGIN > result = COUNT(*) FROM theTable; -- this is where i need help > RETURN result; > > END; 'LANGUAGE 'plpgsql'; See "Executing Dynamic Commands" in the PL/pgSQL documentation: http://www.postgresql.org/docs/8.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
