Re: Create function using quote_literal issues

2019-05-23 Thread Mohamed DIA
I found the solution by defining r as record and using FOR r in EXECUTE v_select Thanks On Thu, May 23, 2019 at 9:49 AM Mohamed DIA wrote: > Hi, > I am trying to use a create function in order to update some values in a > table (see below code). > However, when I run the function, it never ent

Create function using quote_literal issues

2019-05-23 Thread Mohamed DIA
Hi, I am trying to use a create function in order to update some values in a table (see below code). However, when I run the function, it never enters into the following loop *FOR r IN SELECT * FROM immatriculationemployeursucctemp2 where succursale = quote_literal(s.succursale) order by row_numbe