On 2011-09-10, Gabriel Filipiak wrote:
> --bcaec517adbceea3c804ac90a376
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi, this is my first on this list.
>
> I want to know the basics of dynamic sql especially in PostgreSQL. I was
> googling for a while but have no luck for getting a good desc
thank you Sergio.
I decided to use
EXECUTE v_stmt into v_total_pop;
On Thu, Sep 4, 2008 at 2:00 PM, Ivan Sergio Borgonovo
<[EMAIL PROTECTED]>wrote:
> On Thu, 4 Sep 2008 13:41:16 -0700
> "Ruben Gouveia" <[EMAIL PROTECTED]> wrote:
>
> > I created a simple function that i want to use another func
On Thu, 4 Sep 2008 13:41:16 -0700
"Ruben Gouveia" <[EMAIL PROTECTED]> wrote:
> I created a simple function that i want to use another function
> (in the same schema) that will be used to create a sql statement.
> I get the following error when i try this:
>
> *ERROR: syntax error at or near "EXE
On Mar 20, 2008, at 5:28 PM, Erik Jones wrote:
Hi, I've been working on a generic date partitioning system and I
think I've reached something that can't be done, but I thought I'd
post a question to the masses in the hope that I'm missing
something. The basic idea of what I'm doing is som
Gabriel Adolfo Sirni <[EMAIL PROTECTED]> writes:
> Procedure pr_prueba(param in varchar2) is
> v_name varchar2(50);
> BEGIN
> EXECUTE IMMEDIATE ' Begin pr_out_area_code(:1,:2);
> End; ' USING param, OUT v_name;
> END;
You're asking the wrong people; this is not an Oracle mailing list.
>
> I am able to find couple
> of examples for dynamic sql programming through ecpg. But i want to
> do dynamic sql programming through libpq.
> If anyone has programs doing the dynamic sql programmming using the
> libpq libraries please mail to me.
>
Attached you'll find my encapsulated library of
