Re: PL/PGSQL function with parameters

Mike, Jan,

> Michael Ansley wrote:
> 
> With the latest release, I think you can do:
> 
> EXEC ''SELECT * FROM '' || $1;
> 
> or
> 
> DECLARE SQL VARCHAR;
> ...
> SQL = ''SELECT * FROM '' || $1;
> EXEC SQL;
> 
> or something similar (it may be EXECUTE), which uses the dynamic sql
> elements of plpgsql.  I think.

Is this true, Jan?  Does anyone have more specific documentation?
                -Josh Berkus

-- 
______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology      josh@agliodbs.com   and data management solutions       (415) 565-7293  for law firms, small
businesses      fax  621-2533   and non-profit organizations.       San Francisco