I am trying to iterate over an varchar array using plpgsql but i get the
this error:
Error: missing .. at the end of SQL expression
My Table:
TABLE1(
Cars VARCHAR[]
)
My Code
Declare
mycars varchar[];
car varchar;
Begin
For car in SELECT cars from table1 LOOP
RAISE Notice "CAR: %", car
END Loop;
END;
Resume, i have a column with a list of varchar type and i would like to
iterate over this array, is this possible?
Thanks,