| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | "Muthukumar(dot)GK" <muthankumar(at)gmail(dot)com> |
| Cc: | "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 14:58:53 |
| Message-ID: | CAKFQuwZn3_2B1knnMuhhY6UBv8kLHUdzBdT6rVM-ADxR1Vrv-g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Monday, December 14, 2020, 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:
>
>> Hi David,
>>
>> As I am not bit Clea, let me know what I have to do. If possible, please
>> re- write my program.
>>
>
> Like the SQL executor, I have no idea what you are trying to do there.
> Neither the text variable, nor the cursor, nor plpgsql for that matter,
> provide any benefit to executing “select from table”.
>
>
That said, kf you read the “see also” part of the FETCH documentation you
will see that DECLARE is the SQL way to dpecify a cursor, not OPEN.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-12-14 15:24:55 | Re: Dynamic procedure execution |
| Previous Message | David G. Johnston | 2020-12-14 14:56:47 | Re: Dynamic procedure execution |