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 information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco