Skip site navigation (1) Skip section navigation (2)

Re: ill-planned queries inside a stored procedure

From: andrew(at)pillette(dot)com
To: Gaetano Mendola <mendola(at)bigfoot(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: ill-planned queries inside a stored procedure
Date: 2004-08-28 15:13:37
Message-ID: 200408281513.i7SFDbh04877@pillette.com (view raw or flat)
Thread:
Lists: pgsql-performance
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
> procedure?

Responses

pgsql-performance by date

Next:From: Gaetano MendolaDate: 2004-08-28 16:35:18
Subject: Re: ill-planned queries inside a stored procedure
Previous:From: Gaetano MendolaDate: 2004-08-28 11:39:31
Subject: Re: Equivalent praxis to CLUSTERED INDEX?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group