On Monday, December 14, 2020, David G. Johnston <david.g.johns...@gmail.com> wrote:
> > On Sunday, December 13, 2020, Muthukumar.GK <muthanku...@gmail.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.
