Re: Passing a table name to a function for dynamic queries....

Greg Patnude wrote:
> I know I've seen the answer to this here before but cannot seem to find
> it....  Can anyone give me the quick & dirty answer to passing a table name
> to a function like this:
>
> CREATE OR REPLACE FUNCTION tbl_toarray(name) RETURNS text

Build the query as text and use EXECUTE to run it.

--
   Richard Huxton
   Archonet Ltd