Re: PL/PGSQL function with parameters - Mailing list pgsql-sql

From Josh Berkus
Subject Re: PL/PGSQL function with parameters
Date
Msg-id 3A7F95F8.CC0DACBA@agliodbs.com
Whole thread Raw
In response to PL/PGSQL function with parameters  (David Richter <D.Richter@DKFZ.de>)
List pgsql-sql
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
 


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Tuple is too big ...
Next
From: Kovacs Zoltan
Date:
Subject: Re: PL/PGSQL function with parameters