Re: [SQL] PL/PGSQL function with parameters

[Josh Berkus]

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      [EMAIL PROTECTED]
    and data management solutions       (415) 565-7293
   for law firms, small businesses       fax  621-2533
    and non-profit organizations.       San Francisco