I use "EXECUTE" inside a stored procedure for just this purpose. This is not the same as PREPARE/EXECUTE, it lets you send an arbitrary string as SQL within the procedure. You have to write the query text on the fly in the procedure, which can be a little messy with quoting and escaping.
Gaetano Mendola <mendola(at)bigfoot(dot)com> wrote ..
> Hi all,
> do you know any clean workaround at ill-planned queries inside a stored
pgsql-performance by date
|Next:||From: Gaetano Mendola||Date: 2004-08-28 16:35:18|
|Subject: Re: ill-planned queries inside a stored procedure|
|Previous:||From: Gaetano Mendola||Date: 2004-08-28 11:39:31|
|Subject: Re: Equivalent praxis to CLUSTERED INDEX?|