Postgres Pro
Downloads
Home   >   mailing lists

Re: ill-planned queries inside a stored procedure - Mailing list pgsql-performance

From andrew@pillette.com
Subject Re: ill-planned queries inside a stored procedure
Date
Msg-id 200408281513.i7SFDbh04877@pillette.com
Whole thread Raw
In response to ill-planned queries inside a stored procedure  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: ill-planned queries inside a stored procedure
List pgsql-performance
Tree view 
I use "EXECUTE" inside a stored procedure for just this purpose. This is not the same as PREPARE/EXECUTE, it lets you
sendan arbitrary string as SQL within the procedure. You have to write the query text on the fly in the procedure,
whichcan be a little messy with quoting and escaping. 

Gaetano Mendola <mendola@bigfoot.com> wrote ..
> Hi all,
> do you know any clean workaround at ill-planned queries inside a stored
> procedure?

pgsql-performance by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Equivalent praxis to CLUSTERED INDEX?
Next
From: Gaetano Mendola
Date:
Subject: Re: ill-planned queries inside a stored procedure