Re: Dynamic procedure execution

From: Hemil Ruparel <hemilruparel2002(at)gmail(dot)com>
To: "Muthukumar(dot)GK" <muthankumar(at)gmail(dot)com>
Cc: "David G(dot) Johnston" <David(dot)G(dot)Johnston(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Dynamic procedure execution
Date: 2020-12-14 08:36:45
Message-ID: CANW1aT_9kLtPpNsFNKgkCmWwVJZr=i2fYJwhweGrEVfG=Wjfmw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Not to be disrespectful, but you need to at least struggle to find the
answers yourself before posting here.

On Mon, Dec 14, 2020 at 12:02 PM Muthukumar.GK <muthankumar(at)gmail(dot)com>
wrote:

> Hi David,
>
> As I am not bit Clea, let me know what I have to do. If possible, please
> re- write my program.
>
> Regards
> Muthu
>
> On Mon, Dec 14, 2020, 11:43 AM David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> On Sunday, December 13, 2020, Muthukumar.GK <muthankumar(at)gmail(dot)com>
>> wrote:
>>
>>>
>>> v_query := ' OPEN C1 FOR SELECT * FROM public."Bankdetails"';
>>>
>>>
>>>
>>> EXECUTE (v_query);
>>>
>>>
>>>
>> You put the pl/pgsql OPEN command into a string and sent it to the SQL
>> engine via EXECUTE and the SQL engine is complaining that it has no idea
>> what you want it to do.
>>
>> David J.
>>
>>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karthik Shivashankar 2020-12-14 11:38:37 Improving performance of select query
Previous Message Muthukumar.GK 2020-12-14 06:31:36 Re: Dynamic procedure execution